Hello,

I am trying to write a formula that can give me what is the last price that I have sold a particular product.

Basically I have a spreadsheet with something like this:

Date sold / Item / Price
7-jan / A / 10
8-jan / B / 22
9-Feb / B / 15
10-Mar / C / 12
10-Mar / A / 18

I would like in another cell with the item's name the last price of that item.

Item A last price = 18
Item B last price = 15

Any help?