Return cell vallue based on 2 other cell values

[jblayden]

Hi,

I have a spreadsheet in which I have a 'Data' tab and a 'Report' tab. I drop data from an online system in to the 'Data' tab. I have formulas in the 'Report' tab which looks up headers in the 'Data' tab based on the corresponding headers and returns the value from the cell below. That is working fine when the header is in 1 cell. However, I also need the same lookup in other columns but based on 2 separate headers. So in my 'Report' tab I want to lookup 2 separate headers - 1. Standard (will always be on row 1) and Hours (will always be on row 2) and return the value from the cell below the 2 headers (on row 3). The trouble is, the report can differ week to week so the headers and data I need aren't always in the same column each week (headers are always on rows 1 and 2 and data in row 3 and below though). This week the headers I need to lookup are in cells AP1 and AP2 with the cell value I require being in AP3. However the headers could be in anywhere in rows 1 and 2 in the Data tab.

Any ideas would be much appreciated

 

[jblayden]

I don't suppose anyone would be able to help with this query would they?