Is it called 'lookup?'

  • Thread starter Thread starter mythology8
  • Start date Start date
M

mythology8

I know in Access you can have a pull-down list created from a Table, i
your form.
In Excel, you can create a list on sheet 1 (for example), and view tha
list in sheet 2 via a pull-down.
I have forgotten how to do this and would appreciate any help!
Thanks,
Ji
 
Hi

You have to define the list on Sheet1 as named range, p.e. MyList
On Sheet2, select the range you want drop-downs have in, and select from
menu Data.Validation.List
Set validation list source to
=MyList
 
You must log in or register to reply here.

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

execl lookup 1
Copy Data from One sheet to Different Sheets 1
Dymanic List Range 2
How do I move entire row from one excel sheet to another 3
Data Validation and drop-down list using IF, AND and what else? 8
Doing a VLOOKUP (probably using the INDEX and MATCH function), withboth vertical and horizontal valu 2
Dynamic Validation List 1
Formula to consolidate 130 sheets into a summary sheet 6

Back
Top