Hi All,

I need to change the formula below from an array to a normal formula. The formula basically looking through a list and finding the next larger match.the formula i need to change is;

{=LARGE(IF(Data!$A$2:$A$36351=$Q2&"/"&$D2,IF(Data!$E$2:$E$36351<$G2,Data!$E$2:$E$36351)),1)}
Thanks for any help.