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?