|
|
|
|
#1
07-07-2020, 07:31 AM
|
||||
|
||||
1.The IF function does not support wildcards. instead you can use something like=IF(ISNUMBER(search("*"&your_string&"*",cell-nr)),...
2. Your INDEX formulas do not have the match_type (the default is 1 when omitted) so they will not return exact matches ( maybe that is what you want?) 
|
|
| Tags |
| not matching, return wrong result |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Read data on Sheet3 copy to Matching cells on Sheet1 | Potholes | Excel Programming | 2 | 08-21-2019 11:53 PM |
 Match Multi Cells
|
gdavey | Excel Programming | 1 | 09-06-2015 11:09 AM |
| Matching Criteria against a range when criteria is not in contiguous cells?? | GMorris | Excel | 9 | 08-20-2014 02:15 AM |
| Apparently empty (blank) cells aren't empty | daymaker | Excel | 3 | 03-08-2012 03:41 PM |
| How to merge matching cells vertically? | Odiseh | Excel | 1 | 01-02-2010 02:41 PM |
Windows 7 64bit 
Office 2010
Hybrid Mode