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

Attached Images

	1.PNG (10.1 KB, 12 views)
	2.PNG (10.5 KB, 14 views)