ExcelBanter - compare 2 columns

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - compare 2 columns (https://www.excelbanter.com/excel-worksheet-functions/67950-compare-2-columns.html)

BettysAnswer

compare 2 columns

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.

Kevin Vaughn

compare 2 columns

Something like this maybe:

=IF(COUNTIF(Sheet2!$C$1:$C$8,B1)0,B1 & " Found on Sheet2!","")

--
Kevin Vaughn

"BettysAnswer" wrote:

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.

All times are GMT +1. The time now is 03:29 PM.