Hi all,
I have tried to check for solutions but in vain. Hopefully someone can help
I have a 2 different sheet ("sheetA", "sheetB").
SheetA
<tbody>
</tbody>
SheetB
<tbody>
</tbody>
Il cell C1 (SheetA), I would like to multiplying Columns B of SheetA and Column B of SheetB, if cell values in Column A are matching.
Result
<tbody>
</tbody>
Please consider that Column A of SheetA is very long, so I would need a formula that i drag quite easily.
I have tried to check for solutions but in vain. Hopefully someone can help
I have a 2 different sheet ("sheetA", "sheetB").
SheetA
ITALY | 100 |
FRANCE | 200 |
UK | 300 |
ITALY | 20 |
FRANCE | 30 |
UK | 60 |
<tbody>
</tbody>
SheetB
IRELAND | 2 |
UK | 5 |
ITALY | 4 |
FRANCE | 8 |
NORWAY | 3 |
BRAZIL | 2 |
<tbody>
</tbody>
Il cell C1 (SheetA), I would like to multiplying Columns B of SheetA and Column B of SheetB, if cell values in Column A are matching.
Result
ITALY | 100 | 400 |
FRANCE | 200 | 1600 |
UK | 300 | 1500 |
ITALY | 20 | 80 |
FRANCE | 30 | 240 |
UK | 60 | 300 |
<tbody>
</tbody>
Please consider that Column A of SheetA is very long, so I would need a formula that i drag quite easily.