This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi,
I currently working on an Excel workbook where I am taking data from a 3rd Party source and converting it into something I will be able to perform statistical analysis on. The current formula I am using to pull the data together looks like: =XLOOKUP($A2&C$1,ZQM_SLR!$D:$D,ZQM_SLR!$I:$I)
However, some of the data I am pulling together has different specification limits for the same test. For example, some samples have a specification limit between 5-10 and other are 6-11 to keep it simple. These upper and lower limits are in separate columns on the same sheet with the raw data.
Is there a way I can only pull the data together that share the same spec limit by adding an IF function to the formula above? Say if the lower spec limit was 5 it would only pull across those samples and in an adjacent collum have only the samples with a lower spec limit of 6.
Thanks,
Chris
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Could you share some dummy data to test formula and show us an expected result?