Lookup error using pivot table and dates

[AFiadeiro]

Hi all,

I need help! I am doing a sheet which has a pivot table and on the first column it has dates. Then I need to treat the data and I copied the date column to a new column and then did a vlookup: find the date of this new column in the pivot table and returns the value I want to. However the number that gives me is not correct and I know that's because of the date formating. I have tried to copy this column to a new one and change to number format instead of date format but the error keeps the same.

Can anyone help me??

Thanks

 

[NBVC]

Does your Vlookup() formula have the 4th parameter, FALSE (or 0) to indicate find an exact match?

 

[WSanchez]

What exactly is your vlookup formula? As stated above it could be the TRUE/FALSE. FALSE will use only an exact match of the lookup value. While TRUE will use the first closest match; dog before door. You shouldn't have to change format as long as the format is the same in both columns.
You could try the Evaluate Formula function to see step-by-step what the lookup is doing.