Hi,
I want to create a drop down where they select a group and all the names fill in below it.
GROUP 2
JOHN
LARRY
LUCY
GINA
FRANK
ANNA
Cell A5 is my drop down where they will select the group
Starting in A7, I'd like a formula that would look at A5 and start to list the names. Essentially, if they select group 2 then in A7 should be John, A8 should be Larry, A9 should be Lucy, etc. Then cell A13 should be blank because all the names are already listed above.
I will be drawing all this information from a large list which will be sorted by groups.
I want to create a drop down where they select a group and all the names fill in below it.
GROUP 2
JOHN
LARRY
LUCY
GINA
FRANK
ANNA
Cell A5 is my drop down where they will select the group
Starting in A7, I'd like a formula that would look at A5 and start to list the names. Essentially, if they select group 2 then in A7 should be John, A8 should be Larry, A9 should be Lucy, etc. Then cell A13 should be blank because all the names are already listed above.
I will be drawing all this information from a large list which will be sorted by groups.