vlookup with dates made from a dropdown menu

Hi all,

I am new to the forum so apologies if this is in the wrong section.

I am working with some data for power vs time. The data is taken from a data logger which outputs values every five minutes so there is quite a bit of data.
I am looking to use the drop down lists to allow someone to pick: the year, the month & the day. From that I want to be able to do a vlookup of my data with the times chosen.

The data itself outputs time & date as :"dd/mm/yyyy hh:mm:ss" (which is a pain in the ar*e). The problem I am having is I can't get the three separate drop down boxes (i.e. year, month, date) to combine into the correct format (i.e. dd/mm/yyyy) so I can do a vlookup on it. Any suggestions?

Hi DILIPandey,

Thanks for the reply and the welcome message. Yeah it is the combining of three separate numbers to make a date that I don't know how to do. I have attached the sample sheet.

Cheers

Is there one that also included time as well?

i.e. =date & time(....

or something like that?

Basically I want to be able to show graphs over different time periods. At the moment I have data for around 20 days. It is all in one big continuous column though. I want to be able to quickly look at the data for maybe day 13 only without having to go in and change graph ranges.

The way I was planning on doing it was having graphs based on vlookups. Graph a cell range (keep cell range fixed) but use vlookups to transfer the data from the actual data location into that fixed cell range and base it off the drop downs.

The reason there are no time drop downs is because they don't need to be optional. Not yet anyway. I would just put in a fixed start and end time so it would just show data for that day or something like that.

Have the time and date issue solved. I guess its time to see if "whats next" actually works. Will post you the results (if you want) if I get it working.

Thanks again for your help.