Hello Fellow-Excel users,
I am trying to get something to work, let me explain what I am trying:
<tbody>
</tbody>
The table above contains sales volumes per month on a product level.
On another sheet, I want to vlookup the sum of the last 3 months.
So if I vlookup 100.01 I want the outcome to be 150+0+20 = 170.
If I vlookup 200.05 I want the outcome to be 200+250+100 = 550.
Is there any easy way this can be achieved?
Thanks in advance!
I am trying to get something to work, let me explain what I am trying:
Prod Nr | Jan | Feb | Mar | Apr |
100.01 | 100 | 150 | 0 | 20 |
200.05 | 200 | 200 | 250 | 100 |
<tbody>
</tbody>
The table above contains sales volumes per month on a product level.
On another sheet, I want to vlookup the sum of the last 3 months.
So if I vlookup 100.01 I want the outcome to be 150+0+20 = 170.
If I vlookup 200.05 I want the outcome to be 200+250+100 = 550.
Is there any easy way this can be achieved?
Thanks in advance!