Picking a name from a list

  • Thread starter Thread starter qjumper
  • Start date Start date
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.
 
Use of indirect and address function with voolkup is the only solution I see.
It is quite complex but will work for sure
 
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
 
Back
Top