Automatically Show a default value in a drop down list

Hi

I have few columns of dependent lists and I want to show a value in the corresponding columns automatically by selecting a value from a drop down list in the first column.

for Example - in the attached Sheet 4, Cell F2, I have a list of places and from Column G to J are all dependent to the previous column. Now If I select a Place in the cell F2 the corresponding cells should automatically return the first data from the respective drop down list. However, I should also be able to change them if required. Is this possible?

Thanks for helping

Pal

You can add a formula to G2 that will give a specific instance of the INDIRECT() function. Put this in G2 and copy down/Across.

=IF(F2="", "", INDEX(INDIRECT(F2), 1))

Now, in the second section off in P2 I think you need to change the 1 to 2, but you can play with it from here. Get your defaults in each section setup to your liking.

Once you enter a value in F2, the G2:J2 defaults will appear. However, if you make a manual select in any of the drop downs after that, the formula will be gone forever. Remember that. These defaults are only active until you use the drop down once.

Fadzi welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.