How to get the last number from a list?

Question

Google Sheets

Tell me, with what formula can I implement so that as a result of the query "Samsung" gives out the last number from the list (in my case it is 325). I tried it through VLOOKUP - it gives out the first number - 100.

To understand and visualize the situation, I made a small table:
https://docs.google.com/spreadsheets/d/1ITEVisJsYq...

Answer 1

,

=VLOOKUP($E$3,SORT(A2:B,ROW(A2:A)*N(A2:A<>""),0),2,0)

;

=VLOOKUP($E$3;SORT(A2:B;ROW(A2:A)*N(A2:A<>"");0);2;0)