View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BettysAnswer
 
Posts: n/a
Default 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.