Drop down list choosing wrong value

Question

I've tried to create a drop down list with the data verification tool but all the dates in the list is showing the same value.

On the first sheet is the drop down list with a table showing the values. The data is extracted from the second sheet. When creating the drop down list I choose the date on row 5 to the 18th row but the only value that shows in the table is the vaule in row 83.

Answer 1

Thanks for the feedback!

Now, If you set up your list source as an Excel table, all you need to do is add or remove items from the list, and Excel will automatically update any associated drop-downs for you.

• To add an item, go to the end of the list and type the new item.

• To remove an item, press Delete.

Note: If the item you want to delete is somewhere in the middle of your list, right-click its cell, click Delete, and then click OK to shift the cells up.

Hope this helps.

Regards,
Albert

Answer 2

Using Excel 2010 on Windows 10 computer

Answer 3

Hello there,

Thanks for contacting us!

Please, mention the Microsoft application/version you're working with as well as the OS of your computer.

Warm regards,
Albert