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

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Forum statistics

Threads
1,170,941
Messages
5,872,855
Members
432,949
Latest member
yann_ep

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