Hi,
I am preparing an estimation template. I have a source tables which have the
estimated hours of effort and a table which gives options to select the
variables which gives the output.

I have given below examples of both the tables. I have similar source tables
for other products as well.

Please assist me in finding a forumla for multiple variables. The last
column of Estimates table will have the formula. The table has all the
variables possible.

I have tried using IF condition for product and Index and Match for other
variables. It does not seem to be working.

Ex: If i have Affinity product, Release notes as deliverable, and of low
complexity with 5 pages, the result should be 5*4 = 20 Hrs.

Estimates table:

S.No Product Deliverable Complexity of FD No. of Pages
1 Affinity Release Notes Low 5
2 QES User Guides Medium 4
3 Quantim Dictionary Medium 5
4 Interlink File Layouts High 6


Source Table for Estimates for Affinity:

FD Complexity RN UG Dictionary File Layout
Low 4 3 3 8
Medium 6 6 5 8
High 8 8 8 8