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!!
|