Matching cells apparently don't match

Danny cool · #1 07-07-2020, 02:30 AM

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).

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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