SOLVED

I need help in vlookup function

Occasional Contributor
I need help in vlookup function to find last results that not equal zero
5 Replies
Assuming I understood the following should do what you want:
=LOOKUP(2,1/(B2:B9 > 0), B2:B9)
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
best response confirmed by AGB200 (Occasional Contributor)
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)
I can't thank you enough, it works perfectly, thank you very much
You're welcome. Glad I could help & Thanks for marking