| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If function -
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If function -
One way:
=IF(COUNTIF(A1,"*Ford*"),this,that) In article , 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If function -
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 |
|
#4
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If function -
u can use text formula Exact() or Find()
=if(exact(a1,food),this,that) or =if(iserror(find(food,a1),that,this) hope this can be helpful -- Regards, Sebation.G "Jock" ... 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
