Matching a value in a lookup table based on range in the lookup table.

[toughguy19]

I am trying to do something that seems simple. I have the thickness (ex .063) of a sheet of metal in my main table. I now want to lookup what “gauge” it is from a gauge_lookup table. The problem is that in the gauge_lookup table I have a range for each one - 16ga .054 .068 - so that would be three columns. My example would go to the gauge_lookup table find where .063 fits and then return the “16ga” answer. How do I tell it to go look and see where it matches based on the criteria in the gauge_lookup table? Thank you

 

[DRSteele]

Please post some sample data together with expected outcome to make it possible for us to help you.

You can use the available add-in xl2bb.