How to return value that's the most recent?

Hello guys,

I've decided to make my own stock portfolio manager to keep track of my stock purchases.

However, there's one problem: I'm not sure how to return the latest value from rows of data.

Please take a look at the excel file attached to get a better idea of what I need.
The instructions are all inside.

It's still very simple.

Thanks!

Try this:

=LOOKUP(99^99, Trades!$I$5:$I$10000)

Try:

=LOOKUP(2,1/(Trades!$B$5:$B$13=B6),Trades!$I$5:$I$13)

copied down.

Yes, use NBVC (aditional condition)!