Dynamic selection list

Using Index and CountA Formulas, Names and Forms > ListBox to have a list with connected formulas

Can also be used as form to read from a large table in another sheet


After creating two names, one is “Months” having:


And the other one is “Month_All” having:


Draw a listbox using “Developer toolbar”, then make its input list as “Months” name we did above, then use these formulas:


To lookup the other fields once you select from the listbox

You can create a combobox from that “Developer toolbar” with exactly same features

Add a Comment