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.
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!","")
--
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks