| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If function -
Thanks very much
-- tia Jock "Toppers" wrote: perhaps .. =IF(ISNUMBER(FIND("Ford",A1)),"found","not found") FIND is case sensitive, SEARCH is not. =IF(ISNUMBER(SEARCH("Ford",A1)),"found","not found") HTH "Jock" wrote: Can I use a 'LIKE' operator rather than the '=' one? For instance: =If(A1 LIKE "Ford", this,that) If not, is there an alternative which will return partial matches? -- tia Jock |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Embed a countif function in subtotal function? | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
Hybrid Mode
