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 Replacing one text with three in IF(ISERROR(FIND.......Max

Hi,

I have not tried this - please check if it works

=IF(ISERROR(FIND({"FLM","FL","M"},MasterTab!O21)), "",MAX(A$1:A1)+1)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Steve" wrote in message
...
I have this formula.

=IF(ISERROR(FIND("Relief",MasterTab!O21)),"",MAX(A $1:A1)+1)

can it be modified to find three different things instead of "relief". I'd
like it to find: (FLM) (FL) and (M) ?

Much thanks,

Steve