Adresses

  • Thread starter @Homeonthecouch
  • Start date
@

@Homeonthecouch

Hello,
I am having trouble with a spreadsheet I am using to select different postal
addresses.
I want lets say cell b2 to have the input of a name and then the cells below
b3, b4, b5 etc to have the address, area and post code.
I would like the b2 cell to be a drop down selection menu. I think I can
manage that bit but its getting the rest to fill in that I'm struggling
with.

Any help is appreciated

Andrew
 
D

Don Guillett

If I understand you just have cell b3 do a vlookup on cell b2
=vlookup(b2,lookuptable,2)
 
G

Gord Dibben

Andrew

I would re-think the layout of your database.

Most applications that would use your data, such as Word for mailmerging or
labels or envelopes, require the address components to be in a single row, not a
column.

Having said that, VLOOKUP formulas can fill in the cells based upon the value in
your drop-down box.

You need a table with the names and addresses, usually on a second sheet.

See Debra Dalgleish's site for info in VLOOKUPS and also for Data Validation
Drop-down lists.

http://www.contextures.on.ca/xlFunctions02.html

http://www.contextures.on.ca/xlDataVal01.html


Gord Dibben MS Excel MVP
 
@

@Homeonthecouch

I probably haven't explained this very clearly
Sorry

I want to have the address in cells then be able to select them upon calling
the first cell.
So it would look like
Name
address
line 1
line 2
post code
phone number

Then A second set to choose from
Name2
address2
line 12
line 22
post code2
phone number2

I would then have a cell which would give me the choice of Name, Name1 etc
Below that the data for the selected cell would present itself

I hope that's a little clearer if not a little long winded.

Thanks again for any help

Andrew
 
@

@Homeonthecouch

OR
I could just try the vlookup and see that it works :D:D:D:D:D


Many thanks Don

Andrew
 
Top