Range Data Selection

Hello! I'm having a bit of difficulty trying to figure out the proper equation or formula needed for the proper result. This is my work sheet:

Excel Help 1.xlsx

The first table are measurements taken of real life product and whether they pas of fail a range of criteria. The second table is a range of data that is used to verify if the measurements are in a acceptable range. So if a measured width is 0.25 or less, then the minimum thickness would be 0.125 or else it would be labeled a "Fail". Another Example is if the measured width is 0.25<Measurement>0.37, then the minimum thickness would be 0.25 or else it would "Fail". Hopefully this makes some sense?

My issue is that I'm not sure what formula or equation would be best to use for the Criteria 2 column.

Welcome to the forum.

Try in G2, copied down:

Formula:

Please Login or Register  to view this content.

Good luck!

Thanks!

Ah, that makes sense now, thank you! I kept trying the IF, AND & OR in different forms but I couldn't get the to work properly. Thanks again.

You’re welcome. Glad to help.
Thank you for the feedback and for the reputation added.
Have a blessed day.