Lookup to return multiple results - without array

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?

Please Login or Register  to view this content.

Thanks very much

Hi Martin,

Sorry for my lack of details. That method seems to work perfectly, thanks very much