Text To Column problem while getting data from access in excel

Hi all,

I have 2 sheets in Excel 2010:
Sheet 1 where I get data from an access query giving me 2 columns (Date and staff numbers)
Sheet 2 where I have a column of dates entered manually and I am applying Vlookup function to get the staff members from Sheet2 based on the associated date.

The problem is that Vlookup don't give me results unless if I choose the date column got from the query in Sheet2 and convert it using Text To Column button.

Is there a way to fix this, I want to be able to refresh data in Sheet2 and getting results in Sheet1 immediately without having to click the mentioned button above.

sheet1.JPG
sheet2.JPG

Hi there,

Is is possible for you to attach an example workbook for us to be able to look at as the images dont provide enough information.

In the meantime you could try looking to see if your import data is coming through as TEXT instead of as a DATE, as this would evaluate false in the VLOOKUP.

hope that helps.

Aussiexile , you are totally right , it is a conversion issue , the problem is now solved after being helped to convert the date/time from access itself.

Happy to be of service. Happy excelling