Thread: =IF(ISNUMBER(SEARCH("ELB",B2)),"Pipe") add more like "ELB" "FLG"
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
  
Posts: 1,766
Default =IF(ISNUMBER(SEARCH("ELB",B2)),"Pipe") add more like "ELB" "FLG"
Hi,

Array enter the following formula (Ctrl+Shift+Enter). B9:B10 holds your
partial text values

=IF(OR(ISNUMBER(SEARCH(B9:B10,H5))),"Pipe")

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"MAHMOUD" wrote in message
...
=IF(ISNUMBER(SEARCH("ELB",B2)),"Pipe")
HOW TO ADD MORE PARTIAL TEXT LIKE "ELB" "FLG" OR MORE PARTIAL TEXT TO THE
SAME FUNCTION

Reply With QuoteReply With Quote