Lookup

[Guest]

I am trying to use the lookup function, but excel is returning the wrong
result. My formula is LOOKUP(E53,AG1:AG55,AH1:AH55) where e53 is a value
inputted by the user. I want Excel to find the value in e5s in column ag and
grab the corrsponding data in column ah. it isnt finding the corrsponding
data in ah.

 

[Dave O]

Lookup() is intended for one-column operations: check out VLOOKUP().
It will do the job for you.

 

[RagDyeR]

The "Vector" syntax of LOOKUP() uses a column or a row to find a value in
*another* column or row of the same size.

One of the shortcomings of LOOKUP() is that the lookup vector must be in
*ascending* order, otherwise the results may be incorrect, which is what the
case is here, as stated by the OP.