Need Formula Help

[CARBOB]

I need the formula in E17:F19 to return a T(True) if any of the digits in Col B:D match the digits in COL's E:F. The values should be this, E17(F),E18(T),F17(T),F18(T). I must have an error in my formula.

The formula is =IF(SUMPRODUCT(--(ISNUMBER(MATCH(E$16,$B17:$D17,0))))>0,"T","F")

CASH 3 MID 5-6-7 DIGIT STRING.xlsx
	A	B	C	D	E	F
16					0,1,2,4,5,6,7	0,1,3,4,5,8,9
17	03/21/09	8	3	9	F	F
18	03/20/09	6	8	0	F	F
19	03/19/09	6	2	3	F	F
7-STRING T-F

 

[Peter_SSs]

See if this formula, copied across and down, does what you want.

Excel Workbook
	A	B	C	D	E	F
16					0,1,2,4,5,6,7	0,1,3,4,5,8,9
17	03/21/09	8	3	9	FALSE	TRUE
18	03/20/09	6	8	0	TRUE	TRUE
19	03/19/09	6	2	3	TRUE	TRUE
20
7-STRING T-F

 

[CARBOB]

Like a charm!! Thanks Peter!!!!

See if this formula, copied across and down, does what you want.

Excel Workbook
	A	B	C	D	E	F
16	*	*	*	*	0,1,2,4,5,6,7	0,1,3,4,5,8,9
17	03/21/09	8	3	9	FALSE	TRUE
18	03/20/09	6	8	0	TRUE	TRUE
19	03/19/09	6	2	3	TRUE	TRUE
20	*	*	*	*	*	*
7-STRING T-F