Select a customer name and have their address fill in automaticall
 

I would like to be able to select a customer naome on an order form and have
their address fill in automatically. How do I do this in excel 2007

Select a customer name and have their address fill in automaticall
 

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


On Tue, 2 Oct 2007 11:21:02 -0700, Missie
wrote:

I would like to be able to select a customer naome on an order form and have
their address fill in automatically. How do I do this in excel 2007