Joining 2 very long formulas

Hello,
I need to join 2 very long formulas in one cell
=IF(ISERROR(INDEX(INPUT.$A$2:$A$295;MATCH(A3;INPUT.$B$2:$B$301;0)));"";INDEX(INPUT.$A$2:$A$295;MATCH(A3;INPUT.$B$2:$B$301;0)))
And
=IF(ISERROR(INDEX(INPUT.$A$2:$A$295;MATCH(A3;INPUT.$D$2:$D$301;0)));"";INDEX(INPUT.$A$2:$A$295;MATCH(A3;INPUT.$D$2:$D$301;0)))

I cant remember how to do this.

try

Please Login or Register  to view this content.