SOLVED

I need help in vlookup function

%3CLINGO-SUB%20id%3D%22lingo-sub-2571430%22%20slang%3D%22en-US%22%3EI%20need%20help%20in%20vlookup%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2571430%22%20slang%3D%22en-US%22%3EI%20need%20help%20in%20vlookup%20function%20to%20find%20last%20results%20that%20not%20equal%20zero%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2571430%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2571515%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20help%20in%20vlookup%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2571515%22%20slang%3D%22en-US%22%3EAssuming%20I%20understood%20the%20following%20should%20do%20what%20you%20want%3A%3CBR%20%2F%3E%3DLOOKUP(2%2C1%2F(B2%3AB9%20%26gt%3B%200)%2C%20B2%3AB9)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2571567%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20help%20in%20vlookup%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2571567%22%20slang%3D%22en-US%22%3EClose%20enough%20but%20I%20need%20it%20with%20vlookup%2C%20your%20formula%20bring%20last%20number%20that%20not%20equal%20zero%20that's%20okay%20but%20I%20need%20this%20with%20specific%20client%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2571678%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20help%20in%20vlookup%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2571678%22%20slang%3D%22en-US%22%3EAs%20I%20said%20%22Assuming%20I%20understood%22%20but%20I%20did%20not%20fully%20%3A).%20The%20following%20should%20fix%20it%3A%3CBR%20%2F%3E%3DLOOKUP(2%2C%201%2F((A2%3AA9%3DF1)*(B2%3AB9%26gt%3B0))%2C%20B2%3AB9)%3C%2FLINGO-BODY%3E
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