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,...........
kwarden13Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

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

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
Never miss a deadline with monday.com

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:

=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
All Courses

From novice to tech pro — start learning today.