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