Match column headers and add value

[Samadhan Gaikwad]

Hi,

I have main table with many columns. I have to map columns from 2nd table for given rows and add values in table1. Please find below attachments.

 

[Hui]

Using your pictur4 as a template:
O2: =IFERROR(INDEX($B$2:$E$19,MATCH($N2,$A$2:$A$19,0), MATCH(O$1,$B$1:$E$1,0)),0) + IFERROR(INDEX($J$2:$K$10,MATCH($N2,$I$2:$I$10,0), MATCH(O$1,$J$1:$K$1,0)),0)

or see attached file:

 

[Samadhan Gaikwad]

Thank you, Hui! Just one query can we directly modify 1st table because ultimately I want this one to be modified.

 

[Hui]

You can change the elements or the order of the column or row headers as required in either table