View Single Post
  #1   Report Post  
mdawn mdawn is offline
Junior Member
 
Posts: 3
Default 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.