Solved Vlookup changing date completely

May 8, 2017 at 04:12:23
Specs: Windows 7
I am trying to use a vlookup to pull through the appointment date from one excel spread sheet to another.

On the original spreadsheet (generated from a database query) the date shows as 01/02/2017, but the result of the vlookup populates the destination cell with 02/02/2021.

I'm assuming it's a date format issue that's behind it, but I am not sure how to fix it. Any ideas?


See More: Vlookup changing date completely

Report •

#1
May 8, 2017 at 05:04:32
That doesn't sound like a format issue, but it's hard to tell from where I'm sitting. I can't see your formulas or data layout.

Does the 2021 date that was returned actually exist someplace? If it does, that points to a formula issue, e.g. pulling data for the wrong column or something like that.

We would need some more details or a copy of the workbook before we could offer any specific help. If you could upload a non-confidential, non-personal copy of the workbook to zippyshare.com, we could take a look and see what's going on.

Upload the file and post the link back here.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
May 8, 2017 at 05:48:24
✔ Best Answer
In your VLOOKUP() are you specifying an Exact match by using FALSE or Zero in your Range_Lookup section?

IE =VLOOKUP(A1,B1:B20,2,FALSE)

If set at FALSE or Zero, then VLOOKUP will only look for and return an exact match if there is one.
Since your VLOOKUP is returning something, check to make sure it is not set to TRUE or One.

MIKE

http://www.skeptic.com/


Report •

#3
October 30, 2017 at 14:25:19
Hell! I am having the same issue as sweetblasphemy where the vlookup result is a different date, such as "10/21/2021" instead of the "correct" or desired result of "10/20/2017". The referencing table's values, such as date has been Copy/paste as "value" to ensure no links/referenced formulae are causing the issue. any ideas/suggestions? Thank you.

Report •

Related Solutions

#4
October 30, 2017 at 16:43:15
Are you using FALSE (or 0, same thing) as the range_lookup argument?

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code

message edited by DerbyDad03


Report •

Ask Question