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]

OK; seems to be a precision-based problem. In the formula, the target S13 is shown to be .520833333 while K1 shows .52083333333333.

What is odd is that =S13=K1 returns TRUE. A fix is to copy/paste the time values from H13:AK13 into B1:AC1, or vice versa.

Sorry, but I'm hopeless when it comes to time values, but I think these 2 rows must have been seeded in a somewhat different manner.

 

[gcot]

That does work. That's something I've never come across.

Thanks for your help Jon. Very much appreciated.

Gilles