Returning values for multiple matches without array formulas

[Smurphster16]

Hi guys,

I am looking to effectively extract multiple matches without array formulas as the lookup array for the multiple matches is large and slows down my workbook too much.

I have the values, lets call them 'account names', I want to match with as column headers, the lookup column is in another worksheet and will definitely have multiple matches in some cases.

I can use a formula to return all matches for one value in one column header using this formula: =IF(Account_name='Liquidity Ladder Extract'!B2,MAX('Liquidity Ladder Extract'!$A$1:$A1)+1,0) and then looking up 1, 2, 3 e.t.c in the column in which i have this formula, but this solution only works for one 'account name' if you like. - how can i expand this solution across multiple account names without adding more helper columns?

Thanks in advance for your help,

Phil

 

[Marcelo Branco]

We need more information - a small data sample along with expected results would be helpful.

M.