Help with a formula please....

[Alex Caldecott]

Hi All, HNY!

I need a formula to put in D12 & E12 of the plot summary tab and drag down to pull the 1st Fix (AE21) and 2nd Fix (AE40) totals through from the appropriate type tabs.

So I'm assuming it would need to first check the type column on the plot summary tab to then link it to the correct type tab?

Hope I have explained that enough.... screen shots attached.

Appreciate any help!!

Cheers!

 

[hagia_sofia]

Hello, could you please answer some questions related to the data and the expected output?

1) Is it a correct assumption that the data you need to return are scattered accross multiple sheets, i.e. from AH-B to OM11?

2) If 1) is true do those sheets have the same structure or not, i.e. type in B5, plot number in B6 and totals in AE21 and AE40?

3) Should all the plots that belong to the same type have the same total, e.g. AH-B + 29, 30, 31, 35, 36, 27, 38, 39 would have 44.30 and 68.86?