# Vlook up returning 00/01/1900

#### Sandy01UK

##### New Member
Hi I wonder if you guys can help?
I am using the formula
=IF(ISERROR(VLOOKUP(C2,ShedA!C:O,13,FALSE)),"",VLOOKUP(C2,ShedA!C:O,13,FALSE))
The input for the return is a dropdown list with dates.
The Lookup returns 00/01/1900 for blank cells. However this is not for all the cells some cells in my column return a blank and others 00/01/1900 E.g cell O14 returns a blank but O15 00/01/1900 the formula has been dragged down.
This has me stumped, I have searched the web and this forum and not got an exact answer.

Many Thanks
Sandy

### Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use \$ signs: \$V\$2:\$Z\$99 will always point to V2:Z99, even after copying
=IF(ISERROR(IF(VLOOKUP(C2,ShedA!C:O,13,FALSE)=0,"",VLOOKUP(C2,ShedA!C:O,13,FALSE))),"",IF(VLOOKUP(C2,ShedA!C:O,13,FALSE)=0,"",VLOOKUP(C2,ShedA!C:O,13,FALSE)))

Thank you so much worked a treat. Was beginning to pull my hair out!!! Project is over due and this was slowing me down further. Thanks Again Sandy

Replies
2
Views
1K
Replies
12
Views
1K
Replies
4
Views
3K
Replies
3
Views
3K
Replies
1
Views
271

Threads
1,221,417
Messages
6,159,789
Members
451,589
Latest member
Harold14

### 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.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

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

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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