VLOOK UPS

Danielle22103

New Member
Joined
Dec 15, 2005
Messages
13
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!!
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Forum statistics

Threads
1,136,419
Messages
5,675,724
Members
419,584
Latest member
mrh8rr

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top