I need help in vlookup function

[AGB200]

I need help in vlookup function to find last results that not equal zero

[#2]

Assuming I understood the following should do what you want:
=LOOKUP(2,1/(B2:B9 > 0), B2:B9)

[#3]

Close enough but I need it with vlookup, your formula bring last number that not equal zero that's okay but I need this with specific client

[#4 · Accepted solution]

As I said "Assuming I understood" but I did not fully :). The following should fix it:
=LOOKUP(2, 1/((A2:A9=F1)*(B2:B9>0)), B2:B9)

[#5]

I can't thank you enough, it works perfectly, thank you very much

[#6]

You're welcome. Glad I could help & Thanks for marking