How to return initial value of an IF statement



I am attempting to build out an IF statement that contains a long index/match formula in it. I want the IF statement to return the initial value that the index/match statement finds if the logical test is true. Is there a way to go about that without copying and pasting the formula?

=if(INDEX('2019'!$E$5:$BU$133, MATCH(Sheet1!$C$2&Sheet1!$C$3&$D8, INDEX('2019'!$B$5:$B$133&'2019'!$C$5:$C$133&'2019'!$D$5:$D$133,0),0),MATCH(Sheet1!E$7,'2019'!$E$3:$BU$3,0)) > '2019'!E6,

So, if the index/match > 2019!E6, i want to return the index/match value. Thanks for the help!

Continue reading...