Forum Discussion
Determine where a value fits between a table of ranges and pull an associated cell from the row
An Excel table of number ranges (e.g. 0 - 1, 1.1-2, 2.1-3) and an associated field to retrieve when the value being compared against fits in the range. Value passed in is 0.18. This should result i...
=INDEX($C$2:$C$8,MATCH(1,($A$2:$A$8<=E1)*($B$2:$B$8>=E1),0))
With this formula you can enter the search value in cell E1 and the formula dynamically returns the SKU.
- Thank you very much, works great!
