Hi, I am looking for help with a formula to populate a column with data from another by using a dropdown menu.
I have a dropdown menu in A3, the choice is basically 1-5. the 1-5 corresponds to 5 columns containing names.
What I would like to do is use the dropdown menu (already in place), select "1", then all the names under "1" (already on another column) to show below the dropdown menu in A3, select "3" and all the names in the column under "3" will then populate under A3, etc....
table range is E69:I125, E69 contains 1,2,3,4 and 5, rows 70-125 have all the names, 5 columns, 5 lists. Full list of each need to show when Value is selected in A3 from dropdown list.
Any help would be greatly appreciated.
Regards,
Colin.
I have a dropdown menu in A3, the choice is basically 1-5. the 1-5 corresponds to 5 columns containing names.
What I would like to do is use the dropdown menu (already in place), select "1", then all the names under "1" (already on another column) to show below the dropdown menu in A3, select "3" and all the names in the column under "3" will then populate under A3, etc....
table range is E69:I125, E69 contains 1,2,3,4 and 5, rows 70-125 have all the names, 5 columns, 5 lists. Full list of each need to show when Value is selected in A3 from dropdown list.
Any help would be greatly appreciated.
Regards,
Colin.