Adresses

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

@Homeonthecouch - 02 Jul 2006 16:59 GMT

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

Reply to this Message

Don Guillett - 02 Jul 2006 17:14 GMT

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

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

> Hello,
> I am having trouble with a spreadsheet I am using to select different
[quoted text clipped - 8 lines]
>
> Andrew

Reply to this Message

@Homeonthecouch - 02 Jul 2006 19:44 GMT

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

> If I understand you just have cell b3 do a vlookup on cell b2
> =vlookup(b2,lookuptable,2)
[quoted text clipped - 11 lines]
>>
>> Andrew

Reply to this Message

@Homeonthecouch - 02 Jul 2006 19:49 GMT

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

Many thanks Don

Andrew

> If I understand you just have cell b3 do a vlookup on cell b2
> =vlookup(b2,lookuptable,2)
[quoted text clipped - 11 lines]
>>
>> Andrew

Reply to this Message

Gord Dibben - 02 Jul 2006 17:49 GMT

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

>Hello,
>I am having trouble with a spreadsheet I am using to select different postal
[quoted text clipped - 8 lines]
>
>Andrew

Reply to this Message

Rate this thread: