Just make the formula shorter

[rplim2016]

Hi Mr. Excel,

Is there a way NOT to REPEAT the logical_test false statement again, as I wanted the formula to be just shorter.


Example:

from:
=IF(VLOOKUP(D2,Criteria!$C$2:$D$11,2,0)="123",1,
VLOOKUP(D2,Criteria!$C$2:$D$11,2,0))


to:
=IF(VLOOKUP(D2,Criteria!$C$2:$D$11,2,0)="123",1,
some shortcut formula to put the logical_test here to make the words shorter, because logical_test sometimes can be much longer)



Thanks

 

[James006]

Hello,

You could test following :

=SUBSTITUTE([COLOR=#333333]VLOOKUP(D2,Criteria!$C$2:$D$11,2,0)="123",1)[/COLOR]

Hope this will help

 

[Fluff]

You could put the Vlookup in a helper column & then point the If to that column