Vlookup not displaying dates

[danlero]

Good morning
I am not very familiar with vlookup....everything works on my formulas except for the one containing a date.
Instead of pulling up a date, it pulls up a random number. Any ideas?

 

[Special-K99]

Hello doctor, I don't feel well today.
What is wrong with me?

Is that the garage? My car don't work.
What do you think the trouble is?

Supply the formula for crying out loud or shall we simply guess?
Look at the posts by other people on this forum.
They supply a clear description of the problem and any formulas they have used.
Some even supply a sample spreadsheet.

Post a sample spreadsheet with expected results, remove any sensitive data, create a mockup example if necessary.
You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

Attachments

Or upload the file to an online storage site and post a link to it, though some people may not download the file for fear of viruses.

 

[jmacleary]

Whilst I agree with the sentiment of Special-K99's post, I feel its a bit overly sarcastic for a reply to a first-time poster.

Anyway, I'll have a shot at a guess:
If the 'random' number is coming up as something like 42947 (which is todays date in internal excel representation), then it is finding a date - you just need to format the cell with the result in as a date format.

Otherwise, do what Special-K99 suggests and give us enough information to work from.

Regards
John

 

[danlero]

Hello doctor, I don't feel well today.
What is wrong with me?

Is that the garage? My car don't work.
What do you think the trouble is?

Supply the formula for crying out loud or shall we simply guess?
Look at the posts by other people on this forum.
They supply a clear description of the problem and any formulas they have used.
Some even supply a sample spreadsheet.

Post a sample spreadsheet with expected results, remove any sensitive data, create a mockup example if necessary.
You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

Attachments

Or upload the file to an online storage site and post a link to it, though some people may not download the file for fear of viruses.[


=VLOOKUP(J5,Data!L:X,13)

This is the formula I am using which refers to the acquisition date of a piece of equipment

 

[Special-K99]

Formula looks simple enough, as jmacleary says if it's returning a 5-digit number then that's the date, you just need to format the cell.

It's better to replace L:X with a row limit,e,g. L1:X100000 than use the whole columns like L:X

 

[danlero]

This is the date from the corresponding cell

[TABLE="width: 94"]
<colgroup><col width="125" style="width: 94pt; mso-width-source: userset; mso-width-alt: 4571;"> <tbody>[TR]
[TD="class: xl65, width: 125, bgcolor: #FFFFBF"]04/17/07[/TD]
[/TR]
</tbody>[/TABLE]


I get 42776

Formula looks simple enough, as jmacleary says if it's returning a 5-digit number then that's the date, you just need to format the cell.

It's better to replace L:X with a row limit,e,g. L1:X100000 than use the whole columns like L:X

 

[Special-K99]

42776 si 02/10/2017

04/17/2007 is 39189.

Prob best post the spreadsheeet.

Remove any sensitive data, create a mockup example if necessary.
You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

Attachments

Or upload the file to an online storage site and post a link to it, though some people may not download the file for fear of viruses.

 

[danlero]

I changed the format of the cell and the proper information is displayed.
Thank you for the help.....and sorry for my lack of knowing the ins and outs of the community.[


THanks
D


QUOTE=Special-K99;4879750]42776 si 02/10/2017

04/17/2007 is 39189.

Prob best post the spreadsheeet.

Remove any sensitive data, create a mockup example if necessary.
You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

Attachments

Or upload the file to an online storage site and post a link to it, though some people may not download the file for fear of viruses.[/QUOTE]

 

[Special-K99]

I apologise as well.
It's just very frustrating when someone posts a brief description without any formulas or spreadsheet or other information.
It makes it almost impossible to solve.

Nevertheless I'm happy that the problem is resolved.

 

[jmacleary]

All's well that ends well. Glad everyones happy - I am too.