Lookup multiple data points to find info in a single cell

I need to lookup data in a report and pull it into an excel document so that I can better manipulate the info. I need to find data at an intersection based on info in two columns and a single row. I have attached a sample of what I am trying to accomplish. I need to pull data from the report tab based on data in the Location and Act Desc columns based on the date in row 2 and populate the info in the Lookup tab accordingly.

I believe that I will need to use a combination of formulas, but I am unclear how to nest or even go about this solution. Any assistance would be greatly appreciated!