Thread: search Sheet2! for the contents of Sheet1!
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Fester Fester is offline
external usenet poster
  
Posts: 3
Default search Sheet2! for the contents of Sheet1!
Many thanks to all who have helped.
=if(isnumber(match("*"&a1&"*",sheet2!a:a,0)),"Yes" ,"")
worked great and now I can have a good weekkend.
Wes

Reply With QuoteReply With Quote