| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SEARCH function help
Ok, I need to search for partial text matches in an IF statement.
the base formula goes like this: =IF ((ISNUMBER(SEARCH("index", A1), "Indexed", "Not indexed") what i need is basically the same thing.. but looking for more than one search match. ideally something like: =IF((ISNUMBER(SEARCH("index" or "table" or "legend"), a1), "Indexed", "Not Indexed") Make sense? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookup function to search an entire workbook | Excel Worksheet Functions | |||
| a search function | Excel Worksheet Functions | |||
| Search function | Excel Discussion (Misc queries) | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| Search function using commas | Excel Worksheet Functions | |||
Threaded Mode
