List Lookups from a different tab

  • Thread starter Thread starter Pablo
  • Start date Start date
P

Pablo

I am trying to set up a validation type list using values from a different
tab. Every time I try to point to the tab it will not let me.

Any suggestions?
 
Make the list values in the other tab into a named range...

Select the cell that you want to make into a list.
On the formula bar where you see the cell address type in 'MyList' (without
the quotes) and hit enter.

Now on your other sheet when asked to supply the list just type in =MyList

For futher info...
http://www.cpearson.com/excel/DefinedNames.aspx
 
Defined name for the source and refer the name in the validation list text box

=mylist

If this post helps click Yes
 
Back
Top