VLookup not working...Help ASAP

  • Thread starter Thread starter Roberta
  • Start date Start date
R

Roberta

I have two colums
A B
123 142
145 128
124 123

I want a vlookup that will take the number in col A and
lookup in Col b for a match, if a match, 1 will appear and
if FALSE, the #NA appears.

So the formula looks like this right now:
VLOOKUP(A1,$B$1:$B$760,1,FALSE) but even where there is a
match it still shows #NA.

I can't figure out what is wrong. The format of the cells
is General. and I sorted in ascending order col B.
Please reply via email ASAP.
 
try this instead

=ISNUMBER(MATCH(A1,B1:B760,0))

returns true or false

you are using vlookup in the wrong manner
look it up in help
 
Well, without regard to whether you are or are not using VLOOKUP
correctly, I can't reproduce your result. The formula returns 123. Are
you sure you don't have some leading or trailing spaces somewhere?

Alan Beban
 
Back
Top