VLOOKUP

[Robert Lowe]

Hello,
Can someone please help me with VLOOKUP.
=+VLOOKUP("2221",$B:$O,3,FALSE)
returns #N/A (value not available error)
Clell formats are GENERAL.
Thank you
Robert

 

[JE McGimpsey]

First, your + sign is superfluous in XL.

Putting "2221" within quotes makes it a text string. If the "2221"
you're looking for is a number rather than a string, use

=VLOOKUP(2221, $B:$O, 3, FALSE)