![]() |
|
#1
|
|||
|
|||
|
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 |
|
|
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 |