Hi guys,

I've been using the below array formula to do a vlookup function and return the data from the 2nd and 3rd vertical findings of the same lookup criteria. But now, after changing systems at work, I keep getting an "excel ran out of resources" error. I am assuming it is the array formulas that is causing this error, so I was wondering if there are any alternatives to help me get what I need without using an array?

{=INDEX(Data!1:1048576,SMALL(IF(Data!A:A=G2,ROW(Data!A:A)),ROW(2:2)),25)}
Thanks very much