Excel - difficult VLOOKUP question:

i've been breaking my mind for a couple of days on this problem, no one
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 the
relative rows in tab "2"

In other words, I need  to get the values in the colums from B to F" in
tab "2"  based on the time frames in tab 1,  and have them listed in a
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!


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



--
cat3appr

cat3appr;1601390 Wrote:

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

And of course keep in mind that the talented people on here, who is help
you asked for, are not necessarily on here 24/7, so occasionally a reply
can take a little longer than the 30 hours you allowed before giving
up!

So the example figures on tab 2 you have filled in, where on tab 1 do
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 a
helpful reply...


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



--
Spencer101