SOLVED

combining two if statements in one with a vlookup

%3CLINGO-SUB%20id%3D%22lingo-sub-2174135%22%20slang%3D%22en-US%22%3Ecombining%20two%20if%20statements%20in%20one%20with%20a%20vlookup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2174135%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%20my%20formula%20works%20if%20I%20enter%20it%20individually%20but%20as%20soon%20as%20I%20combine%20into%20one%20then%20it%20adds%20instead%20of%20using%20the%20scenarios%2C%20any%20advice%20on%20how%20to%20bring%20two%20scenarios%20together%20in%20one%20formula%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(R15%3D3%2C0%2C0)%2BVLOOKUP(E16%2C'Point%20System'!U%3AY%2C4%2C0)%3F(IF(R15%3D4%2C0%2C0)%2BVLOOKUP(E16%2C'Point%20System'!U%3AY%2C5%2C0))%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2174135%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor

Hi all, my formula works if I enter it individually but as soon as I combine into one then it adds instead of using the scenarios, any advice on how to bring two scenarios together in one formula?

 

The scenarios - if Q15=3 then the answer must return the values as per vlookup but if Q15=4 then it should return another value as per vlookup.

 

=IF(R15=3,0,0)+VLOOKUP(E16,'Point System'!U:Y,4,0)AND/OR(IF(R15=4,0,0)+VLOOKUP(E16,'Point System'!U:Y,5,0))

2 Replies
best response confirmed by Janedb (Contributor)
Solution

@Janedb 

=VLOOKUP(E16,'Point System'!U:Y,R15+1))

Thank you! You are a star as always