VLookup Help

[nsantos]

Hi everyone, I'm having some trouble with this VLookup. Can someone give me a hand with what I'm doing wrong?

Thanks!

 

[Nebu]

Hi:

The formula should be like this

=VLOOKUP(B2,$K$2:$L$132,2)

Thanks

 

[nsantos]

I did that initially but I'm still getting values in some cells in column I when I should be getting "#N/A"

 

[AlanSidman]

Nebu forgot to put a False as the last criteria--a typo I'm sure.
The formula should look like this: =VLOOKUP(B2,$K$2:$L$132,2,FALSE)

 

[nsantos]

That worked!

Thanks!!