problem with vlookup dates

[meg may]

Hi all,

Im having trouble with looking up dates using vlookup function between tabs on the spreadsheet. It was returning #N/A and i read it was relating to the date/time so i created a INT column to round and changed formula to look up the column and now its just returning 0/01/1900.

Sorry if its a bit of blonde questing but im at a bit of a loss.

Cheers

 

[cyrilbrd]

Hi,
would you mind posting a few lines of sample so members could propose solutions to your query?
just show what you would like to get and what you are presently using.

 

[meg may]

no worries

D3= vendor name
=vlookup(D3,Table, (column 16 which is a date converted to a whole number), FALSE)

result is 0/01/1900
if i change the lookup column to another one that isnt a date it looks up fine.

 

[cyrilbrd]

like this?

Excel 2013
	D	E	F	G	H	I	J	K	L
2					name	this	that	ect	date
3	him				he	1	6	11	1/23/2015
4					she	2	7	12	1/24/2015
5	1/26/2015				her	3	8	13	1/25/2015
6					him	4	9	14	1/26/2015
7					they	5	10	15	1/27/2015
meg may

Are some of the cell in Column 16 blanks?
Your query result looks like the formula is unable to find a match.
Do make sure that your data in the first column doesn't have leading spaces, trailing spaces.