Hi there, I have a sales sheet that I use VLOOKUP for to return an item value for SKU which met my needs until now. The problem that I have is that the current VLOOKUP formula that I have at present will only work out the value of one item as it only references the SKU and performs the VLOOKUP to return a value for that SKU. I also need my formula to calculate the price for multiple items which I will show below.
<tbody>
</tbody>
The formula would basically lookup a table and if the QTY SOLD was 1 it would return the value of 1 item (10) but for each additional item sold it would add on the corresponding value which for 2 items would be (10+9), 3 items (10+9+9) 4 items (10+9+9+9) etc.
Is this possible?
QTY SOLD | SKU | VALUE I WOULD LIKE RETURNED | VLOOKUP COLUMN: SKU | VLOOKUP COLUMN: QTY SOLD = 1 | VLOOKUP COLUMN: QTY SOLD = EACH ADDITIONAL ITEM | |
1 | SKU-TEST1 | 10 | SKU-TEST1 | 10 | 9 | |
2 | SKU-TEST1 | 19 | ||||
3 | SKU-TEST1 | 28 |
<tbody>
</tbody>
The formula would basically lookup a table and if the QTY SOLD was 1 it would return the value of 1 item (10) but for each additional item sold it would add on the corresponding value which for 2 items would be (10+9), 3 items (10+9+9) 4 items (10+9+9+9) etc.
Is this possible?