Finding Value from Tables

[ofd2008]

Hi,
There are 132 different tables. I want to add values according to two variable values from the tables.
l added a sample file. Solution can be macro function or formula.
Regards.
Thanks for your helping.

[FlameRetired]

Is this what you had in mind?

[sktneer]

Not sure exactly what you are trying to achieve. BTW try this to see if this works as per your requirement.

Please Login or Register  to view this content.

Please find the attached sheet and click on the Green Button to get the desired output in col. AO and AP and let me know if this is what you want.

[ofd2008]

Thank you.
FlameRetired, your formula is about sum and index function. But l only add value according to bold values from tables.
sktneer, macro code is working perfect. Again, thank your very much.
Regards.

[sktneer]

Glad I could help. Thanks for the feedback.