Looping an Array Formula for Multiple rows

Hello,

I wanted to do a multiple return vlookup so I used an Index formula. I have account names and am trying to vlookup contacts associated with those accounts (4 max). So I have a list of Accounts all with 3 blank rows in between them. How do I loop an array formula? So far I have the code..

Please Login or Register  to view this content.

This finds the 4 contacts associated with the first account in C5 which I named the cell "myVar". I now want it to find the contacts associated with the accounts in C9, C13, C17 and so on until the first empty cell.

Help please!

Hi,

Welcome to the forum

Please note: The code below is air code! I have not tested or tried it in Excel.
Please test on a copy of your file...

Please Login or Register  to view this content.

Thanks, Rudi! This totally worked! I changed the R[-4],R[-3] to R1,R2 to make it constant and it's awesome. Just figuring out how to drop down the formula to the rows below it.

Yes R1,R2 is good..a bit of an oversight on my part.

I'm not sure what you mean by drop down the formula to the rows below it? Is it not simply supposed to occur every fourth row?
If you need further assistance, please elaborate.
TX

Yes R1,R2 is good..a bit of an oversight on my part.

I'm not sure what you mean by drop down the formula to the rows below it? Is it not simply supposed to occur every fourth row?
If you need further assistance, please elaborate.
TX

Sorry...I must admit that I did overlook those necessary details.
Try this version now...

Please Login or Register  to view this content.

Please note that I got assistance to help solve this from an MVP in Eileen's Lounge, here: http://www.eileenslounge.com/portal.php

You're welcome.
Glad to help