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

x
  • 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

Example

Column A                     Column B
10/20/2011                  =vlookup(43637,...........
0
kwarden13
Asked:
kwarden13
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:

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/A_2637-Six-Reasons-Why-Your-VLOOKUP-or-HLOOKUP-Formula-Does-Not-Work.html

BTW, 43637 corresponds to a date of 21 June 2019...
0
 
kwarden13Author Commented:
Both of them say date formats when I go to format
0
 
kwarden13Author Commented:
I even pciked the same format
0
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:

=VLOOKUP(40836,...)

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.
0
 
jppintoCommented:
Could you post a sample file for us to take a look please?
0
 
kwarden13Author Commented:
The 43637 was just an exmple I through out not what it actually corresponds to
0
 
Patrick MatthewsCommented:
Please post a sample file
0
 
Rory ArchibaldCommented:
If you change the format of your column A dates, do they actually change display? If not, then they are text.
0
 
sabouilleCommented:
it will failled to find a match if not using the same data types !
0

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