Thread: Select a customer name and have their address fill in automaticall
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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

Reply With QuoteReply With Quote