# Vlookup returning #N/A some of the time

#### gcot

##### New Member
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
ABCDEFGHIJK
18:008:309:009:3010:0010:3011:0011:3012:0012:30
2Sunday333344
3Monday58111214131312109
4Tuesday47991011101198
5Wednesday4678101010888
6Thursday3568998888
7Friday3467888877
8Saturday2344556554
Shifts By Half Hour

### Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

#### just_jon

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

#### gcot

##### New Member
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

##### Legend
Type

=S13=K1

in a cell -- TRUE or FALSE?

True

And =D12=A3 ?

True

#### just_jon

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

#### gcot

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

#### just_jon

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

Replies
0
Views
392
Replies
2
Views
937
Replies
2
Views
2K
Replies
3
Views
5K
Replies
2
Views
562

1,181,606
Messages
5,930,869
Members
436,764
Latest member

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back