Returning last value in cell based on value of another cell

[VBAhelp33]

Hi all,

I am trying to create a formula that will return the values that are highlighted in red in the below screenshot but am not having much luck. Basically, I would like to return the previous transaction value for that particular stock. If there has been no previous transactions for that stock, I'd like the cell to be blank & if I have purchased the stock in the past, I'd like the cell to return the last transaction value for that particular stock.

Does anyone have any ideas how I can do this?

 

[Phuoc]

Try this in cell G2:

=IFERROR(LOOKUP(2,1/($B$1:B1="buy")/($C$1:C1=C2),$F$1:F1),"")