Lookup, Table lookup, Table

Hello - can anyone assist? I have edited my question since I expect it was too vague.

How to make a 2-Variable Table where the 2 changing cells are an array and they themselves also depend on a set of scenarios?

Excel template attached with relevant fields coloured in yellow. I seem to think it involves lookup functions and 2-Variable Table.

The Objective is to populate the Table A at row 72 with the NPV result generated in Cell E69.
Example of calculation - the weighted NPV is added to Cell E72 of Table which is NPV in Cell E69 x probability in row 14 for each of A-I.
Each row in the Table is a probability weighted NPV for a given Approach 1-5.
Each time a parameter in the excel changes, it needs to auto-calculate and update the Table.
Each instance of the probability weighted NPV (example Cell E72) is taken from Cell E69 x probability weight.
The NPV in Cell E69 is a function of Schudule D (row 62) and Schedule B (row 51).
As the calculations are performed, each row in Schedules A & C are auto entered into Schedules B & D respectively.
The results that appear in Schedules B & D are default rows 41 and 51 for Schedules B & D respectively.

Thanks in advance.

David