| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to use IF AND and wildcard for text ending?
Hello,
I'm trying to get a cell to show a message if two other cells contain some specific text: ex. =IF(AND(A3="RRA05*";C3="KRF");"Tipo 4";"Tipo 1") but I'm having trouble with the wildcard * I have already tried ...A3="RRA05?????"... as this article code is always 10 digit long, but it also doesn't work Should I format the cells in any specific way (as "text" or something else) so it will work? Thank you very much in advance, for all the help provided Susana |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formula containing text and wildcard | Excel Worksheet Functions | |||
| sumproduct with wildcard for text? | Excel Worksheet Functions | |||
| If text already contains a wildcard how do I countif, sumif etc.? | Excel Discussion (Misc queries) | |||
| Using IF to find text + wildcard? | Excel Worksheet Functions | |||
| COUNT or COUNTIF using wildcard text? | Excel Worksheet Functions | |||
Threaded Mode
