Adding an IF condition to an existing IF condition

[jeriss]

Hello everyone,


Please check the file attached, and have a look at the cells GENERAL! A35 and A36.

=IF(I33=0,VALIDATIONS!AE3,VLOOKUP(VLOOKUP(G1,VALIDATIONS!G:AX,18,0),TRANSLATIONS!A:C,MATCH(I4,TRANSLATIONS!A1:C1,0),0))

=IF(I33=0,VALIDATIONS!AE4,VLOOKUP(VLOOKUP(G1,VALIDATIONS!G:AX,19,0),TRANSLATIONS!A:C,MATCH(I4,TRANSLATIONS!A1:C1,0),0))

These formula returns the value of the cells VALIDATIONS! AE3/4 if GENERAL! I33 equals zero. Otherwise, it returns some other value (this part doesn't matter).


Now I need to add a condition in these formula, as below.

If GENERAL! I3 = VADLIATIONS! AD2, then the first formula should return VALIDATIONS! AE2

If GENERAL! I3 = VADLIATIONS! AD2, then the second formula should return VALIDATIONS! AE4

Your help would be highly appreciated in this.

Thanks
Simon

[Keebellah]

I don't really see what you want here
MAybe you should explain a little more

[Squeaky]

Hi Simon, Just put the new conditions at the beginning of the formula. Make sure "VALIDATIONS" is spelled correctly as well.
equals IF(GENERAL!I3=VALIDATIONS!AD2,VALIDATIONS!AE2,IF(I33=0,VALIDATIONS!AE3,VLOOKUP(VLOOKUP(G1,VALIDATIONS!G:AX,18,0),TRANSLATIONS!A:C,MATCH(I4,TRANSLATIONS!A1:C1,0),0)))
and equals IF(GENERAL!I3=VALIDATIONS!AD2,VALIDATIONS!AE4,IF(I33=0,VALIDATIONS!AE4,VLOOKUP(VLOOKUP(G1,VALIDATIONS!G:AX,19,0),TRANSLATIONS!A:C,MATCH(I4,TRANSLATIONS!A1:C1,0),0)))
-Squeaky

[jeriss]

Thanks Squeaky, your answer worked perfectly well !