DropDown from vlookup

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
 
B

Bob Phillips

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)
 
Top