Index Lookup - Multiple Criteria

[JonesyUK]

Hi Experts, please assist:

I need to populate a grid (yellow cells B2:C3) which picks up Grand Totals for Budget and Actuals by Month by finding the correct data from a PIVOT TABLE which can be seen here:

https://ibb.co/i0Ow9K

Normally, there is a BUDGET column, and an ACTUAL column for each period, but this is not always the case. Some departments, have no Budget, and others might have no Actuals. So in this example, cell B6 might say "Actual" or cell B5 might be month "P4"

Any ideas please?

Thanks!

 

[mrshl9898]

Hi, this seems to be working for me.

=IF(INDIRECT(ADDRESS(MATCH("Personnel Number",$A$1:$A$15,0),MATCH(B$1,$B$5:$G$5)+1))=$A2,INDIRECT(ADDRESS(MATCH("Grand Total",$A$1:$A$15,0),MATCH(B$1,$B$5:$G$5)+1)),IF(INDIRECT(ADDRESS(MATCH("Personnel Number",$A$1:$A$15,0),MATCH(B$1,$B$5:$G$5,0)+1))=$A2,INDIRECT(ADDRESS(MATCH("Grand Total",$A$1:$A$15,0),MATCH(B$1,$B$5:$G$5,0)+1)),""))