DropDown from vlookup

  • Thread starter Thread starter RobertLees
  • Start date Start date
R

RobertLees

Hi

How is this done ? I want to create a drop-down list on a cell, that is
populated from a named range. The user selects from the list to get it's
value for the cell. I've seen this done, but don't know how.

Thanks
Robert
 
This sounds like a simple Data>Validation, type of list, and set the list to
point at a range, such as =M1:M20

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combobox 4
Help With MS Access 4
How to create a dropdown list that populates with another list 2
Data Validation and drop-down list using IF, AND and what else? 8
Drop-down list and error message 1
data validation list 17
Excel Already selected values from DropDown list dynamically updating on multiple sheets 10
VLookup not working - missing entries or not returning correct values 1

Back
Top