View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default Find 3 If(Iserrors instead of 1

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