Thread
:
Drop down data validation
View Single Post
#
3
Posted to microsoft.public.excel.misc
paul
external usenet poster
Posts: 247
Drop down data validation
have a named range that is actually A1&" "&B1
when you select your item use say vlookup(result,a1:a10,1,false)
--
paul
remove nospam for email addy!
"Stephen Reid" wrote:
Hi
I know how to create drop down lists in data validation but I am looking to
get a little extra. Currently I create a list in A1:A10 create a range name
for the list and then use that named range in the data validation screen.
However, what I want now is:
Create a list in A1:A10 and a description in B1:B10 for example:
A B
1001 Coffee
1002 Tea
1003 Hot Chocolate
I would like the to see both the name and the description in the drop down
but once selected only select the data from column A. Don't know if this
can be done, but any help would be appreciated.
Thanks
Stephen
Reply With Quote
paul
View Public Profile
Find all posts by paul