Lists

  • Thread starter Thread starter wella
  • Start date Start date
W

wella

How do I create a list where I can chose a name from and the appropriat
address will be displayed in a desired cell(s)
 
Hi wella


Select the cell for the List and go to Data>Validation and choose "List"
from the "Allow" box.

The list can be typed seperated by commas, e.g

Cat,Dog,Mouse etc

Or, refered to a range of cells housing the list.

IF the range of cells resides on another Worksheet, name the range first
(eg MyRange) then use
=MyRange as the Source.

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****
 
Hi

You would need to create a list with the first column for the 'lookup' name,
the second for address line 1, then address line 2 etc. You then use
multiple VLOOKUP functions to call each bit of the address. You could also
make the selection of the name work through Data Validation, which avoids
having to type the name exactly as it is in the list - you can simply look
it up from within the cell.

Andy.
 
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

data validation list 17
Help with Excel phone list 1
Can I save different print areas? 3
Auto-fill from Validation List 2
How do I rotate a landscape page 180 degrees for printing? 3
Drop-down list and error message 1
Column data comparison - what has been deleted and what has been added 8
Fill in text from drop down list box in Excel 3

Back
Top