how to look up a colum or row in an array
I would like find a formula that would report the value in column 1 of a table when looking in a table of numbers.
For example
gear low med high
a1 75 27 63
a2 55 26 52
a3 1 2 3
b1 4 7 11
b2 101 25 3
b3 85 28 3
I would like a formula to look up the value 85 in the array and report the gear settings for the value 85.
|