VLOOK UPS

[Danielle22103]

I am trying to do a search on a cell, relating to one column on another spreadsheet. If that data is in the other spreadsheet, i want the cell to either show YES OR NO against the cell on the same row.

=VLOOKUP(B1, 'Final Reval File'!$C$2:$C$3855, 1)

VLOOKUP COLUMN B
#N/A 54535
54541 54541
54541 54545
54541 54560
54541 54716
54541 54719
54541 54721
i want the vlookup formula to say the number in column B is either in the search selection of the other spreadsheet or not. Why is the same number showing in the vlook up that does not relate to the number in column B? and how to i complete the formula to show either YES or NO.

Can Someone Help Me?
Thanks


From: Don't have a freaking clue and starting to lose it!!

 

[Krishnakumar]

Hi,

=ISNUMBER(MATCH(B1,'Final Reval File'!$C$2:$C$3855,0))

hth