LOOKUP command

[Guest]

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,a226,a227,a228},{c219,c220,c221,c222,c223,c224,c225,c226,c227,c228})

 

[Harlan Grove]

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,a226,a227,a228},
{c219,c220,c221,c222,c223,c224,c225,c226,c227,c228})

=LOOKUP(A17,A219:C228)

 

[Biff]

Hi!

Try this:

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

Biff

 

[Harlan Grove]

Try this:

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

....

Why include the 4th argument?

 

[Biff]

I always default to FALSE out of habit.

Biff

...
...

Why include the 4th argument?