Shouldn't I just be able to change the index range to match the index tab in the formula wherever "Results Key" appears?
Ie if there are 6 products in the results key tab shouldn't the formula read:
=INDEX('Results Key'!$D$1:$D$6,SUMPRODUCT(SMALL(--('Results Key'!$B$1:$B$6<='Data Information'!$B$4)*IF('Data Information'!$B$5="",1,--('Results Key'!$C$1:$C$6='Data Information'!$B$5))*$A$3:$A$6,SUMPRODUCT(--('Results Key'!$B$1:$B$6<='Data Information'!$B$4)*IF('Data Information'!$B$5="",1,--('Results Key'!$C$1:$C$6='Data Information'!$B$5))-1)*-1+A3)))
Bookmarks