Help to put a default value in DropDown List

**AE10** · 10-07-2019, 04:10 PM

Hi Experts

Please see attached workbook.
Sheet 1 has Customers in column A and a dropdown list in Column B.
This dropdown list populates from the data in sheet(DATA) by matching customers and bringing back a list from Notes if there is a match of customers.
If there is no match, i will get "No Notes for this customer" in my dropdown.
If the customer is blank, i will get "Select customer code first" in my drop down.

What i want is to always have in my dropdown list a default value of "Always".
So if you select a customer, it will first have "Always" in my drop down and thereafter have the associated "Notes" in the dropdown list that matches the customer.

Please help
Thanks
AE10

**Pete_UK** · 10-07-2019, 04:12 PM

Duplicate thread.

**jeffreybrown** · 10-07-2019, 04:13 PM

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-pro...down-list.html