Dear mdawn, Good Evening.
It´s not dificult to do what you need.
But your explanation is a little confuse.
You have 4 columns.
a) In which column do you desire to search the value?
b) Do you need as an answer all the other three columns?
After your answer I believe that the solution will be ok.
I think it´s possible to use MATCH Function and/or Vlookup Function.
I´m Wainting for your answer
Mazzaropi
-------------------------------------------------------------------------
Quote:
Originally Posted by mdawn
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.
|