[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 538
  • Last Modified:

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,...........
1 Solution
Patrick MatthewsCommented:
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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 !

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now