returning pivot data without "getpivotdata"?

[adgroves]

I'm trying to create a formula in sheet 1 (below), that checks the column heading and the row heading, and then returns the data in the corresponding row and column heading from sheet 2 (which is a pivot table, and hence the data changes rows/columns each time it updates).

I don't seem to have the latest version of google sheets yet, so I'm not being offered 'getpivotdata' as an option... is there any way I can achieve this?


Sheet 1 (forecast vs actuals)

Row A

Consultancy

<colgroup><col style="width: 100px"><col width="66"><col width="66"></colgroup><tbody>
[TD="colspan: 2"]09-2015 (Sept)[/TD]

[TD="align: center"]Forecast[/TD]
[TD="bgcolor: #f3f3f3, align: center"]Actuals[/TD]

[TD="align: right"]2,805 [/TD]
[TD="bgcolor: #f3f3f3, align: right"] [/TD] [/TR] [TR] [TD]Hardware[/TD] [TD="align: right"]50 [/TD] [TD="bgcolor: #f3f3f3, align: right"]- [/TD] [/TR] </tbody>[/TABLE] Sheet 2 (actuals) [TABLE] <colgroup><col style="width: 100px"><col width="100"><col width="100"></colgroup><tbody>[TR] [TD="bgcolor: #ead1dc"][/TD] [TD]row A [/TD] [TD]row B[/TD] [/TR] [TR] [TD][/TD] [TD="align: right"][/TD] [TD][B]09-2015 (Sept)[/B][/TD] [/TR] [TR] [TD]1[/TD] [TD][B]Consultancy[/B][/TD] [TD]2000[/TD] [/TR] [TR] [TD]2[/TD] [TD][B]Hardware[/B][/TD] [TD][/TD] [/TR] </tbody>[/TABLE]