Thread: isnumber search
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default isnumber search
How about:

=IF(ISNUMBER(SEARCH("FHA",E6)),"FHA",IF(ISNUMBER(S EARCH("VA",E6)),"VA",IF(ISNUMBER(SEARCH("streamlin e",E6)),"streamline","conv")))

--
Gary''s Student - gsnu201003
Reply With QuoteReply With Quote