Lookup if based on date

Hi,

I have one workbook, Price Aggregate, that that has a sheet of data, specifically prices by date. One of the sheets is a summary sheet that adds certain prices from the other sheets together to aggregate a total price, based on a date entered on the summary sheet. So I enter 5/1 in cell B2, the total prices update on that sheet. Enter 6/1 in cell B2, prices up date to reflect those prices.

Now, I have another workbook, Lookup, where I need to lookup the Aggregate Price from the first workbook, based on the date. I have a table on the second workbook that has the dates listed that need to be looked up, and it should then return the
aggregate price from the first book. Does this make any sense?

Thanks