LOOKUP command
 

Hey.
I am trying to use the following lookup but it keeps returning an error.
Can you help?
Thanks :)
=LOOKUP(a17,{a219,a220,a221,a222,a223,a224,a225,a2 26,a227,a228},{c219,c220,c221,c222,c223,c224,c225, c226,c227,c228})

"excelnewbie" wrote...
I am trying to use the following lookup but it keeps returning
an error. Can you help?
=LOOKUP(a17,{a219,a220,a221,a222,a223,a224,a225,a 226,a227,a228},
{c219,c220,c221,c222,c223,c224,c225,c226,c227,c22 8})

=LOOKUP(A17,A219:C228)

Hi!

Try this:

=VLOOKUP(A17,A219:C228,3,0)

Biff

"excelnewbie" wrote in message
...
Hey.
I am trying to use the following lookup but it keeps returning an error.
Can you help?
Thanks :)
=LOOKUP(a17,{a219,a220,a221,a222,a223,a224,a225,a2 26,a227,a228},{c219,c220,c221,c222,c223,c224,c225, c226,c227,c228})

"Biff" wrote...
Try this:

=VLOOKUP(A17,A219:C228,3,0)
....

Why include the 4th argument?

I always default to FALSE out of habit.

Biff

"Harlan Grove" wrote in message
...
"Biff" wrote...
Try this:

=VLOOKUP(A17,A219:C228,3,0)
...

Why include the 4th argument?