Offsetting values in a table

[sunnydeol89gister]

Hi,

I'm trying to offset the values in this table where they match (signs are inverse though). For example:

- Yellow cells - Column heading A1 to Row A2 matches Column heading A2 to Row A1
- Orange cells - Column heading A1 to Row A4 matches Column heading A4 to Row A1

Ideally I would like to match these off in another table with the same column headings and rows.

Thanks

I'

 

[Legacy 143009]

You can directly equalise to the source cells if the table structures are the same.

=B2

You can use the formula below if you want a fancy way. Assuming row headers are on Column A and column headers on the first row:

=INDEX($B$2:$S$19,MATCH(B$1,$B$1:$S$1,0),MATCH($A2,$A$2:$A$19,0))