Hi all,
I think I can solve this with using the index match formula. Here are the two tables that I have. I am looking for a formula to insert in table 1 that I can copy and paste (with absolute values) that pulls the total amount per month and per city from the 2nd table below.
Much appreciated!
<tbody>
</tbody>
<tbody>
</tbody>
I think I can solve this with using the index match formula. Here are the two tables that I have. I am looking for a formula to insert in table 1 that I can copy and paste (with absolute values) that pulls the total amount per month and per city from the 2nd table below.
Much appreciated!
City | February | March |
Tokyo | Formula goes here | Formula goes here |
Milan | Formula goes here | Formula goes here |
<tbody>
</tbody>
Month | Tokyo | Milan |
February | 20000 | 14500 |
March | 21000 | 15000 |
<tbody>
</tbody>