Thread: Extracting Text String that matches with list
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
  
Posts: 896
Default Extracting Text String that matches with list
would this be of any help:

=IF(FIND(E1,A2),E1,)

presuming E1=USA, E2=England etc.
Reply With QuoteReply With Quote