Hi Steve

Try

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

--
Jacob (MVP - Excel)


"Steve" wrote:

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