toughguy19
New Member
- Joined
- Oct 19, 2007
- Messages
- 5
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