Error comparing and getting result of between Two columns

shilabrow · #1 06-18-2014, 06:19 PM

Look at all the IDs in Cell A and check if its in Cell B, If in Cell B, Yes and if Not No in Cell C. I tried using the find function but not getting it.
The Vlookup is giving me what it finds in Cell B and putting #NA in other which I don’t like. Any help appreciated. Thanks
Please Ignore my Cell Arrangement of C A B - There are 3 columns below.

C A B
Result ID ID
No 112 145
No 123 168
No 137 179
No 139 185
Yes 145 191
No 158 197

Yes 168
No 177
Yes 191
Yes 197
No 199

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Comparing 2 columns of Text	Berk21	Excel	9	02-03-2012 12:19 PM
Advanced Filter - Comparing Two Columns	apolloman	Excel	5	07-27-2011 04:54 AM
How to compare 2 columns with other two columns in EXECL 2007?	Learner7	Excel	5	06-12-2010 09:54 AM
macro for comparing data from 3 columns and pasting into another worksheet	ashukla	Excel	1	06-24-2009 05:01 PM
Comparing Data	leroytrolley	Excel	1	08-09-2008 08:34 PM