vllokup help

[billyfaith]

I am importing data into a macro enabled excel worksheet and it is converting some of the data to a date. Data import should display 11-01, excel is converting it to 1-Nov. I have created a vlookup table to convert it back to 11-01 but it does not seem to be working. My data is imported into column G, my table array is in a worksheet labeled vlookup, the values I want to return are in the 2nd column and I want to return an exact match and so my formula is:
=VLOOKUP($G2,vlookup!$A$1:$B$359,2,False)
Any ideas. General or text formatting of the cells DOES NOT WORK.

[billyfaith]

I just opened a blank excel worksheet(not macro enabled) and imported the data and the formula works. Anybody know why?

[julhs]

Hi billyfaith,

This may be a case of the blind leading the blind, however try custom formatting the date column with “mm:dd”. May be more to it than that but it is a starting point.

regards

julhs

[billyfaith]

Thanks for the tip but I resaved my worksheet and input the vlookup formula and it works now.

[Fidd$]

Julhs's advice is sound. Would most likely to be a cell formatting issue. If the formula works in a new workbook, check the cell's formatting in that workbook and then compare with the cell's formatting in your 'actual' workbook.

Hope this helps