Picking a name from a list
 

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.
--
Qjumper

Picking a name from a list
 

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



"qjumper" wrote:

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.
--
Qjumper

Picking a name from a list
 

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"qjumper" wrote:
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.
--
Qjumper