Hi!

I've come across with this question several times and I never managed to come up with a solution. I believe it's quite simple.

Say I have the following IF (dummy) function:


=IF(NOT(ISERROR(VLOOKUP(A1,C1:D100,2,0)+VLOOKUP(A1,C1:D100,3,0)),VLOOKUP(A1,C1:D100,2,0)+VLOOKUP(A1,C1:D100,3,0),"")
As you may have noticed, I've repeated the VLOOKUP sum both in the conditon argument and in the IF TRUE argument.
The question is: is it possible to avoid this type of statement? Sometimes it can get PRETTY BIG and repetitive...

Thanks in advance!