Automatically Show a default value in a drop down list

[Fadzi]

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.

Hie. this is exactly what i need. but how can i do this using a Defined name for example in this sheet attached below

[Winon]

Hello Fadzi,

Why don't you keep it simple and just use the DropDown, as shown in the attached sample Workbook?

Regards.