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.
 
Back
Top