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.

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

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.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

"Dave O" wrote in message
ups.com...
Lookup() is intended for one-column operations: check out VLOOKUP().
It will do the job for you.