How to look up Values by Date?

[deejabram]

In Short

My Workbook has multiple tabs.

On my tabs I have information for the entire year
On my Summary Tab, I want to look up the Value for "TODAY" only, and I want the spreadhseet to display that value on the Summary Tab.

Please see attached example. Any help Anyone can give would be greatly appreciatedExample.xls:

[sweep]

Hi,

In B2 use the following format of formula

=INDEX(DK!B2:B20,MATCH(TODAY(),DK!A2:A20,0))

this follows the general form

=INDEX(array_from_which_to_return_data,MATCH(lookup_value,lookup_range,0))

[deejabram]

Thank you sweep. I have just learned a new function. I didnt know about the Index function. I greatly appreciate it.

[deejabram]

Follow up question: What modifications do I make to the index formula if I wanted to simply display yesterday's information instead of today?

[sweep]

Excel's UOM for time is 1 day, so:

=INDEX(DK!B2:B20,MATCH(TODAY()-1,DK!A2:A20,0))

[deejabram]

Thanks again.