Drop Down List I havee a sheet that I would like to put a drop down list on, I h

Question

Drop Down List

I havee a sheet that I would like to put a drop down list on, I have 11 sheets where this information is stored. What I want to do is have a drop ddown list that will open then allow me to pick another drop list from there. Example, the first drop down list will list 11 golf courses by name, when I select a golf course it will show a drop down list of the Tees available.

Example first drop down list is

Ponce

Balbboa

Magellan

Isabella

When I click on one of these I want a drop down list to appear that will have

Black tees

Blue Tees

White Tees

Then when I click on one of these it will populate all the information

any help would be appreciateed.

Thank You!!

Explanation / Answer

It will be pretty easy to do with the sheet you are using, but will take a little time. Once you have the system from Deb's page down pat, make sure you understand named ranges. Right now, your sheet gets its data using vLookup, and named ranges in the Course Info sheet.

=VLOOKUP($C4,TableTeeMarkers,COLUMNS($C4:D4),FALSE)

Make a new sheet in the workbook for each course. Follow the same convention for naming ranges as you have in your current sheet, except each range name must be unique:

PonceTeeMarkerTable

BalboaTeeMarkerTable

MagellanTeeMarkerTable

IsabellaTeeMarkerTable

Then in the vLookup Formula for each cell do something like (one line of untested code):

=if(SelectedCourse=Ponce,VLOOKUP($C4,PonceTableTeeMarkerrs,COLUMNS($C4:D4),FALSE),

if(SeelectedCourse=Balboa,VLOOKUP($C4,BalboaTableTeeeMarkers,COLUMNS($C4:D4),FALSE),

if(SelectedCourse=Magellan,VLOOKUP($C4,MagellanTableTeeMarkers,COLUMNS($C4:D4),FALSE),

if(SeleectedCourse=Isabellla,VLOOKUP($C4,IsabellaTableTeeMarkers,COLUMNS($C4:D4),FALSE),""))))

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.