Thread: match word in one column form list in another
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Filter by first letter Filter by first letter is offline
external usenet poster
  
Posts: 7
Default match word in one column form list in another
So to clarify the list in column C has thousands of different company names
and I am trying to see if that name is in column B which has hundreds of names

"daddylonglegs" wrote:


If your lists are in columns B and C then in A1 copied down

=IF(ISNUMBER(MATCH(B1,C:C,0)),"Match","")


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=564427


Reply With QuoteReply With Quote