Need a better explanation.

it works great for (FLM), however, I now need
it to also find (M)'s and (FL)'s Something like:
=IF(ISERROR(FIND("(FLM)","(M)","(FL)",MasterTab!O 21)),"",MAX(A$1:A1)+1)

OK, does that mean:

If the cell *does not* contain the string (FLM) *or* the string (FL) *or*
the string (M) then return blank, otherwise return MAX(...).

???

--
Biff
Microsoft Excel MVP


"Steve" wrote in message
...
I posted this a week ago, and did get a couple of responses, but they did
not
work. So I'm trying again, thinking that the wealth of knowlege here is
such
that, if at all possible, you all would be able to solve it.

Here is my formula ( provided by this group a few months ago).

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

it works great for (FLM), however, I now need it to also find (M)'s and
(FL)'s Something like:

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

Is that possibe ?

Thanks,

Steve