VLOOKUP issue

[St3ff3ns]

Hi Guys,

Quite a stupid question but I cannot get my Vlookup formula working,

I have put you file in attached to help you to see how it is working,

Vlookup from sheet 2 towards sheet 1(basic data),

I am looking the delivery date corresponding to the given document in sheet 1, but I am always getting a N/A even if the data is present in sheet 1

any idea how to get it solved ? many thanks in advance

[BadlySpelledBuoy]

The values in column A on Sheet1 are stored as text rather than numbers hence the VLOOKUP not working.
Convert them to numbers and all will work fine.

1) Copy a blank cell
2) Select column A on Sheet1
3) Right click anywhere in column A and select Paste Special
4) Select "Add" in the window that pops up and click OK

This will convert the text values to numbers.

BSB.

[St3ff3ns]

Thanks ! it was stupid but was blocking me ! is now working perfectly

[BadlySpelledBuoy]

Glad I could help

Thanks for the rep.

Don't forget to mark the thread as SOLVED.

BSB

[asif78612]

Hi,

through vlookup data u can use this formula.
Formula. VLOOKUP(A5,Sheet1!$A$2:$B$20000,2,FALSE).
first in your file you just change the column A to number format
then u can use Vlookup.
after using vlookup formula in sheet 2 column B u just change the format to date format.
then u will get the result.
I hope u will get the result what u have requested.