Is it called 'lookup?'

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
 
A

Arvi Laanemets

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
 

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

Drop down lists in seperate columns 5
execl lookup 1
No option to create a list in SharePoint Site 0
Copy Data from One sheet to Different Sheets 1
You'll need a new app to open this about link 1
Excel does not accept text format! 0
Multiple Email Accounts and Calendars 0
Duplicate hashtags in OneNote 0

Top