Picking a name from a list

Q

qjumper

I would like to pick a name from a drop down list and use the selected name
in a formula.

I have set up the names and entered the values. I have created the drop down
list but whenever I try to use the name selected my formula does not treat
the selection as a name.

Could anyone help.
 
P

Prashant Runwal

Use of indirect and address function with voolkup is the only solution I see.
It is quite complex but will work for sure
 
M

Max

If your DV (data validation) droplist names are defined ranges (named ranges),
try wrapping INDIRECT around the DV cell,
Eg: = VLOOKUP(B2,INDIRECT(A2),2,0)
where A2 contains the droplist for the named ranges,
which would be used as the table array in the vlookup

If the DV is just to select text, then it should work as-is, unless there
are extraneous white spaces within the names returned by the DV throwing the
matching off, Wrap TRIM around it,
Eg: =VLOOKUP(TRIM(A2), ....)
where A2 contains the droplist for the names
 

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

How do I create a small array from a larger one? 3
Filtered drop down list 2
drop down list should remember selection. 6
Drop down list - how doo I make selection disapear? 4
Data validation only works once 1
Formulas with drop down list data 1
How to force cell input from a List? 3
If word from list selected adjoining cell to downfill with a code 1

Top