| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
| where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
| Despite data existing in Excel 2002 spreadsheet Find doesn't find | Excel Discussion (Misc queries) | |||
| 'find' somtimes can't find numbers. I folowd the 'help' instructi. | Excel Worksheet Functions | |||
| How do I find a file/spreadsheet that Excel says is Already open but I can't find it? | Excel Discussion (Misc queries) | |||
Threaded Mode
