Need help with a formula to give Pass/Fail results for items with different limits

[Stryfe]

Hello,

Thank you for taking the time. I've done something similar but not to this degree. I've included a sheet to illustrate my need.

In column B, operators will put the sample name and in column C they will put the test results. I would like column D to enter in "Pass" or "Fail" based upon the results.

cells H2:K3 has the limits which the results must be within that range to pass. I was trying a few different formulas but can not get it to work.

Any help or attempt to help is greatly appreciated.

[JohnTopley]

=IF(AND($C3>=VLOOKUP($B3,$N$2:$P$5,2,FALSE),$C3<=VLOOKUP($B3,$N$2:$P$5,3,FALSE)),"Pass","Fail")

N:P is a lookup table: See attached

[Stryfe]

Thank you so much!

I was in a totally different direction trying iserror and match instead of vlookup. Thank you again for the help and the education.

[Stryfe]

My apologies John, it says I can't add reputation and I give some to other people. You must've helped me about two months back. I will get it in the future

[JohnTopley]

no problem!