Range Name in Data Validation not working

Heinrichdp

New member
Joined
Nov 23, 2019
Messages
1
Reaction score
0
Points
0
Excel Version(s)
2016
I'm trying to create a dynamic drop down list in excel 2016 using Data Validation.

I created Named Tables containing the list details.

I entered the list name in the Data Validation section, but it does not want to except it?
 

Attachments

  • Range Name Error.jpg
    Range Name Error.jpg
    94 KB · Views: 9
You'll need to create a named range based on the table range - a bit counter-intuitive, but should work.
 
Back
Top