Vlookup returning #N/A some of the time

[gcot]

Anyone know why =VLOOKUP($D$12,$A$1:$AC$8,MATCH(S$13,$A$1:$AC$1,0),FALSE) is returning #N/A while it's working in other cells. D12 is the day of the week, in this case Monday.

I checked to make sure the times were formated the same in both ranges and it looks the same.

Any help would be appreciated.

Thanks.

VL Schedule Recommendation March 2004.xls
	A	B	C	D	E	F	G	H	I	J	K
1		8:00	8:30	9:00	9:30	10:00	10:30	11:00	11:30	12:00	12:30
2	Sunday					3	3	3	3	4	4
3	Monday	5	8	11	12	14	13	13	12	10	9
4	Tuesday	4	7	9	9	10	11	10	11	9	8
5	Wednesday	4	6	7	8	10	10	10	8	8	8
6	Thursday	3	5	6	8	9	9	8	8	8	8
7	Friday	3	4	6	7	8	8	8	8	7	7
8	Saturday	2	3	4	4	5	5	6	5	5	4
Shifts By Half Hour

 

[just_jon]

Is D12 exactly equal to Monday, and what is S13? Is A3 exactly = Monday?

 

[gcot]

Yes A3 and D12 = exactly Monday. S13=12:30 in the same time format as in range A1:AC1

This formula returns the correct values in J35 to R35 but in S35 returns #N/A which corresponds to the S13 as the Match value.

 

[just_jon]

Type

=S13=K1

in a cell -- TRUE or FALSE?

 

[gcot]

True

 

[just_jon]

And =D12=A3 ?

 

[gcot]

True

 

[just_jon]

And we've not dropped any of the anchors to the references in the formula?

 

[gcot]

The only part of the Vlookup formula that's changing is the match lookup value in row 13 (J13 to AK13).

 

[just_jon]

I can't duplicate; if you'd like to email the wb, send me a PM and I'll reply back w/ addy.