DateValue vs. Date

I have a column of dates that are formated as dates

In the next column i have a vlookup

For some reason when i evaluate the formula the date is  showing as a datevalue so its making the vlookup come back with an N/A

Any help would be appreciated


Column A                     Column B
10/20/2011                  =vlookup(43637,...........
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

Patrick MatthewsConnect With a Mentor Commented:
VLOOKUP will fail to find a match if you are not using the same data types.  Thus, if you have a column of text values that LOOK like dates, but you use a true date or numeric value in your VLOOKUP, VLOOKUP will not find the match.

Have a look at this article for more troubleshooting tips:

BTW, 43637 corresponds to a date of 21 June 2019...
kwarden13Author Commented:
Both of them say date formats when I go to format
kwarden13Author Commented:
I even pciked the same format
Never miss a deadline with

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Patrick MatthewsCommented:
And BTW, if you use:


and one of your date values is 20 Oct 2011, as above, VLOOKUP will find it, as long as it really is a date value, and not text.
Could you post a sample file for us to take a look please?
kwarden13Author Commented:
The 43637 was just an exmple I through out not what it actually corresponds to
Patrick MatthewsCommented:
Please post a sample file
Rory ArchibaldCommented:
If you change the format of your column A dates, do they actually change display? If not, then they are text.
it will failled to find a match if not using the same data types !
All Courses

From novice to tech pro — start learning today.