Match date formula not working

[shobolos]

Can anyone identify why the formula to match dates is not working, or alternatively provide a formulated solutions that does work?

Excel 2010
	A	B	C	D	E	F
1		01-Jul	02-Jul	03-Jul	06-Jul	07-Jul
2		Wednesday	Thursday	Friday	Monday	Tuesday
3	A B	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!
4	C D	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!
5	E F	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!
6	G H	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!
7	I J	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!
8	K L	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!
9			Fridays		Thursdays
10	A B	C D	E F	G H	I J	K L
11	30-Jul	05-Jul	31-Aug	06-Jul	02-Jul
12	31-Jul	06-Jul	02-Jul	07-Jul	09-Jul
13	01-Aug	07-Jul	08-Jul	08-Jul	16-Jul
14	02-Aug	08-Jul	09-Jul	09-Jul	23-Jul
15	03-Aug	09-Jul	16-Jul	10-Jul	30-Jul
16	04-Aug	10-Jul	22-Jul	11-Jul	06-Aug
17	05-Aug	11-Jul	23-Jul	12-Jul	13-Aug
18	06-Aug	12-Jul	06-Aug		20-Aug
19		12-Aug	03-Jul		27-Aug
20		13-Aug	10-Jul
21		14-Aug	17-Jul
22		15-Aug	24-Jul
23		16-Aug	31-Jul
24		17-Aug	07-Aug
25		18-Aug	14-Aug
26		19-Aug	21-Aug
27		20-Aug	28-Aug
28		21-Aug
29		22-Aug
30		23-Aug
31		24-Aug
32		25-Aug
33		26-Aug
34		27-Aug
Sheet1

Cell Formulas
Range	Formula
B3	=MATCH(B$1,SUBSTITUTE(INDIRECT("H11")," ","_"),0)

 

[gaz_chops]

What are you trying to match the date to? What results are you expecting?

 

[shobolos]

I'm trying to match the dates (B1:F1) to the table below (A11:F34) using named ranges, hence the use of the Indirect function.

From a list of names (replaced by A_B, C_D etc) I have unavailable dates, in no particular order.

I'm then trying to see from all of the available working days in July & August, which days are available for scheduling.

 

[shobolos]

Must've had the 'Monday morning blues' - I've resolved this post myself - I had the Indirect & Substitute functions the wrong way around!