Text To Column problem while getting data from access in excel

[SubZero99]

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

[Aussiexile]

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.

[SubZero99]

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.

[Aussiexile]

Happy to be of service. Happy excelling

[vlady]

FORUM MODERATOR'S REQUEST:

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as "SOLVED".
For the meantime I'll do it for you.

How?
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Note:
You can also thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given.
By doing so you can add to the reputation(s) of those who helped and shared their time in helping you.