drop down selection to populate all related accounts formula help

Hello,

Was hoping for some assistance with a formula that will identify a member ID number that will populate and change in a specific cell on my form page and when a number populates in that cell it will pull from another worksheet all affiliated accounts affiliated to that member. Appreciate your time and efforts!

I suppose that there was typo in "Assrears!G7", it should be "11111111", not "01111111"

In D14, drag down and accross:

Please Login or Register  to view this content.

It is differential a litle bit in output direction: "accross then downward", not "down then across" as per your mockup outcome. Hope it is OK for you. Anyway, if is not accepted, there is another solution for it, if needed.

bebo-Thanks so much! Your formula worked beautifully! I did drag it across (from left to right) in my workbook, which I'm limited to 7 cells in that direction and three rows below those same cells that I can use. I need to have at least 21 cells with this formula, which would require me to use rows below it too. Can I do that using this formula or do you think your other option would be better for that? Thanks again!