Hi All,
In a sheet I have a named range with 2 columns, named "StoreViews".
ID Description
1 Dutch B2B
2 German B2B
3 English B2B
4 Dutch Consumer
5 German Consumer
6 English Consumer
7 Dutch
8 German
9 English
10 All Stores
I would like to reference this named range in a data validation on a second sheet.
However... I want to display the descriptions and store the ID's of the named range.
How do I do that?
If I simply set the data validation to the named range, I get values from both columns.
Any pointers are greatly appreciated!
Thanks.
Bookmarks