#1
|
|||
|
|||
Matching cells apparently don't match
Hi, So i have two cells that have B8 "22b" and the formula (INDEX('Data Entry'!$C$2:$BNW$2,(MATCH(F4,'Data Entry'!C1:BNW1)))) returns "22ba" and the formula below. IF("*" & $B8 & "*"=(INDEX('Data Entry'!$C$2:$BNW$2,(MATCH(F4,'Data Entry'!C1:BNW1)))),1,0) The wild card has worked for me in the past but has stumped me this time. The source and B8 both have a mixture of letters and numbers. the first two are always digits and the third a letter. The source might have two letters but the calculation max is one (like in the above example). |
#2
|
|||
|
|||
Not sure why the wild card is not working without seeing the workbook, but it might be more efficient to use the left function around the index & match?
Just an idea |
#3
|
||||
|
||||
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 |