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