Does anybody know why this formula does not work? I don't think I have too many arguments in my IF formula as the perimeter is 3 and I only have 3 filled out...
=INDEX('R'!$K$3:$K$51,SMALL(IF('R'!$J$3:$J$51=Comparisons!AO9,ROW('R'!$J$3:$J$51)-ROW('R'!$J$3)+1,VLOOKUP(AO9,'R'!J2:K50,2,0),2),1)