Find the Last Price with formula

In attached file, defined what is wanted.
I can find the last price value by a helper column.
Bu I want to use a single formula without helper column.

Thanks in advance for any reply and help.

Regards,
turist

Put this array* formula in cell K2:

=LOOKUP(9E+99,IF(A:A=J2,B:B))

then copy down. You don't need column C.

*An array formula needs to be committed using the key combination of Ctrl-Shift-Enter (CSE) rather than the usual <Enter>.

Hope this helps.

Pete

Dear Pete_UK.
Thanks for prompt reply and help.

Great , it works.

Regards,
turist

Dear Ace_XL.
Thanks for reply and help.
It works, great.

Regards,
turist