elsone31
06-21-2016, 11:58 AM
Good Afternoon,
I have this formula that works as I need it, but as you can see it is lengthy, any help in cleaning it up would be appreciated.
=IFERROR(IF(F$1="","*"&INDEX('2 YEARS PRIOR'!$F$2:$BK$3255,MATCH('Combine Score'!$E10,'2 YEARS PRIOR'!$E$2:$E$3255,0),MATCH('Combine Score'!F$2,'2 YEARS PRIOR'!$F$1:$AV$1,0)),IF(F$2="",INDEX('PRIOR YEAR'!$F$2:$AV$3650,MATCH('Combine Score'!$E10,'PRIOR YEAR'!$E$2:$E$3650,0),MATCH('Combine Score'!F$1,'PRIOR YEAR'!$F$1:$AV$1,0)),INDEX('PRIOR YEAR'!$F$2:$AV$3650,MATCH('Combine Score'!$E10,'PRIOR YEAR'!$E$2:$E$3650,0),MATCH('Combine Score'!F$1,'PRIOR YEAR'!$F$1:$AV$1,0))&"-"&INDEX('2 YEARS PRIOR'!$F$2:$BK$3255,MATCH('Combine Score'!$E10,'2 YEARS PRIOR'!$E$2:$E$3255,0),MATCH('Combine Score'!F$2,'2 YEARS PRIOR'!$F$1:$BK$1,0)))),"")
Thanks a bunch!
I have this formula that works as I need it, but as you can see it is lengthy, any help in cleaning it up would be appreciated.
=IFERROR(IF(F$1="","*"&INDEX('2 YEARS PRIOR'!$F$2:$BK$3255,MATCH('Combine Score'!$E10,'2 YEARS PRIOR'!$E$2:$E$3255,0),MATCH('Combine Score'!F$2,'2 YEARS PRIOR'!$F$1:$AV$1,0)),IF(F$2="",INDEX('PRIOR YEAR'!$F$2:$AV$3650,MATCH('Combine Score'!$E10,'PRIOR YEAR'!$E$2:$E$3650,0),MATCH('Combine Score'!F$1,'PRIOR YEAR'!$F$1:$AV$1,0)),INDEX('PRIOR YEAR'!$F$2:$AV$3650,MATCH('Combine Score'!$E10,'PRIOR YEAR'!$E$2:$E$3650,0),MATCH('Combine Score'!F$1,'PRIOR YEAR'!$F$1:$AV$1,0))&"-"&INDEX('2 YEARS PRIOR'!$F$2:$BK$3255,MATCH('Combine Score'!$E10,'2 YEARS PRIOR'!$E$2:$E$3255,0),MATCH('Combine Score'!F$2,'2 YEARS PRIOR'!$F$1:$BK$1,0)))),"")
Thanks a bunch!