Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
List Lookups from a different tab
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
List Lookups from a different tab
Watch this 5 min video:
How to setup a data validation drop down list: http://youtube.com/watch?v=t2OsWJijrOM -- Biff Microsoft Excel MVP "Pablo" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
List Lookups from a different tab
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 -- HTH... Jim Thomlinson "Pablo" wrote: 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
List Lookups from a different tab
Defined name for the source and refer the name in the validation list text box
=mylist If this post helps click Yes --------------- Jacob Skaria "Pablo" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookups | Excel Discussion (Misc queries) | |||
lookups | Excel Worksheet Functions | |||
two lookups? | Excel Discussion (Misc queries) | |||
lookups | Excel Discussion (Misc queries) | |||
LOOKUPS - Creating LOOKUPs where two different values must BOTH be satisfied. | Excel Worksheet Functions |