compare 2 columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using Excel 2003, need to compare column B on spreadsheet 1 to column C on
spreadsheet 2 and get results if a match is found. In column B the name
Betty appears, I want to know if it appears anywhere in column C on the other
spreadsheet.
 
Something like this maybe:

=IF(COUNTIF(Sheet2!$C$1:$C$8,B1)>0,B1 & " Found on Sheet2!","")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

comparing columns in two spreadsheets 1
Multiple List Analysis 0
Differences between columns 3
Look Up 2
Copying formulas across columns 2
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
VLOOKUP and return formula 1
Moving info from rows to columns 2

Back
Top