difficult VLOOKUP question:

[cat3appr]

i've been breaking my mind for a couple of days on this problem, no on
seems to have found a solution. Please see the attachment.

- in the first tab "1" in the attached xls I have a series of rows
left colum a date and right column a start and end time

- in tab "2" I have another list of values by date and time

- i need to create an output in which for every time range in tab "1"
as in example, from 16:11 to 19:37 on the 29/04/2012 , I get th
relative rows in tab "2"

In other words, I need to get the values in the colums from B to F" i
tab "2" based on the time frames in tab 1, and have them listed in
new tab

can anyone help?? thank you!

+-------------------------------------------------------------------
|Filename: problem.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=352
+-------------------------------------------------------------------

 

[cat3appr]

yep... I thought it was difficult but not impossible.. thanks anyway

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[Spencer101]

yep... I thought it was difficult but not impossible.. thanks anyway!

Perhaps if you gave some more information someone would be able t
help.

And of course keep in mind that the talented people on here, who's hel
you asked for, aren't necessarily on here 24/7, so occasionally a repl
can take a little longer than the 30 hours you allowed before givin
up!

So the example figures on tab 2 you have filled in, where on tab 1 d
they come from?

Are they averages or static figures that are just looked up?

Details like that will make a big difference to how quickly you see
helpful reply..

+-------------------------------------------------------------------
+-------------------------------------------------------------------