Simi
New member
- Joined
- Feb 10, 2012
- Messages
- 190
- Reaction score
- 0
- Points
- 0
- Location
- Utah, USA
- Excel Version(s)
- Version 2002 Build 12527.20194
I am having trouble with an Index/Match look up. I am entering 2 values and to check against, then return the 3rd value from the lookup table.
I am trying to get it so the input doesn't have to match the lookup table exactly. I have attached a woorkbook with an example.View attachment Index-Match-help.xlsx
The table on the left which searches for depth 2 1/2, width as noted isn't working properly.
The results I want should be as follows.
if depth is 2 1/2 and width is <= 6 3/16 use 0.822
if depth is 2 1/2 and width is > 6 3/16 <= 7 3/8 use .980
if depth is 3 and width is <= 6 3/16 use 0.986
if depth is 3 and width is > 6 3/16 <= 7 3/8 use .1.176
I am trying to get it so the input doesn't have to match the lookup table exactly. I have attached a woorkbook with an example.View attachment Index-Match-help.xlsx
The table on the left which searches for depth 2 1/2, width as noted isn't working properly.
The results I want should be as follows.
if depth is 2 1/2 and width is <= 6 3/16 use 0.822
if depth is 2 1/2 and width is > 6 3/16 <= 7 3/8 use .980
if depth is 3 and width is <= 6 3/16 use 0.986
if depth is 3 and width is > 6 3/16 <= 7 3/8 use .1.176
Last edited: