Lookup

[Confused]

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.

[swatsp0p]

What you need to use is VLOOKUP. Your formula would look like this:

=VLOOKUP(E53,AG1:AH55,2)

(note: the ',2' tells the function to look in the 2nd column in the defined range)

Give it a try!

Good Luck

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

Regards,

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

"Dave O" <[email protected]> wrote in message
news:[email protected]...
Lookup() is intended for one-column operations: check out VLOOKUP().
It will do the job for you.