Auto filling name and address on invoice

[Guest]

I want to choose a name from a drop down box in cell D7 and then have cells
D10, J10, M10 auto fill with the correct street address, city and state
respectively. I don't know where to start.

Joe

 

[Gord Dibben]

Use a Data Validation dropdown for choosing the name.

VLOOKUP formulas will pull the data to appropriate cells.

See Debra Dalgleish's site for more on VLOOKUP and Data
Validation lists for entering the choices.

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

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

Note the section on using DV lists from another worksheet by naming the list.


Gord Dibben MS Excel MVP

 

[Debra Dalgleish]

You can use VLookup formulas to fill in the address information. There's
a sample here, that fills in parts of an order form based on user
selections from dropdown lists:

http://www.contextures.com/xlOrderForm01.html

 

[Guest]

I followed the links and downloaded the sample files, tried to recreate them
as written and grounded out when I tried to add a customer list. I failed to
mention I was using XL2007 and step 8 stumps me, can't figure out how to
click add.

Further down in create customer dropdown and lookup, step 4, custList was
not available as a source. Thats where I am, could use further direction.

 

[Debra Dalgleish]

Did you download the sample file? It might help you see how the order
form works.

In Excel 2007, for step 8, click OK, to close the dialog box.
Then, on the Ribbon, click the Formulas tab, and click Define Name.
Create the next name, CustLookup, as described in the instructions.

After you create the CustList name, you should be able to use it in the
data validation dialog Source box: =CustList