How do I return most recent value based on row and column conditions?

[rebelfish]

Hi! I am challenged with a report. I have two worksheets - one for data, one that summarizes it into a report. For the summary, I want certain cells to display the value by looking up today's date in a column and the current time in a row. For example:

On the tab "Summary", cell B4 is to display number of reservations.
Cell D3 contains the current date.
Cell E3 contains the current time.

In the "Data" tab, the columns contain dates (i.e., J3 is 5/4/09) and the rows contain times (i.e., B12 = 2:00:00 PM). The value in cell J12 is 264. That means that on 5/4/09 at 2:00:00 PM we had 264 reservations.

The lookup I want to do on the summary tab is:
In Cell B4 display the current number of reservations by looking up the current date as displayed in D3 in tab "Data" and the current time (rounded back to the previous hour) as displayed in E3 in tab "Data".

The trick is that each column in "Data" is a different date of the month.
Any ideas on how to do this?

 

[millhouse123]

Would a formula like this work:
=VLOOKUP(E3,Worksheetnamehere!A2:Z10000,MATCH(E1,Worksheetnamehere!B1:M1),FALSE)

THe Vlookup determines which row to pull the data from and the match tells the formula what column to pull the data from.

 

[millhouse123]

Of course you would need to adjust all of the ranges to fit your spreadsheet.