PDA

View Full Version : Compare 2 Columns & Return In Third



pmdcorabia
06-01-2007, 07:58 AM
I have a sheet with 2 big columns (3000 each). I want to search each element from the first column in the second column and put a message "Yes" if it is and "No" if it isn't, at the same position in the third column. How can i do that? I want to use the sheet for more than 3000 lines (about 5000). I attached an example.

Bob Phillips
06-01-2007, 09:16 AM
Put this formula in C1

=IF(B1="","",IF(ISNUMBER(MATCH(B1,A:A,0)),"Yes","No"))

and copy down