Thread: How do I use auto fill to add information from an existing source?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
  
Posts: 9,221
Default How do I use auto fill to add information from an existing source?
Assume Sheet2's cols A to F is the existing reference, where col A contains
the names, cols B to F contain the other info, eg: address, city, state, zip
and phone number

In Sheet1,
you have the names listed in A2 down
Put in B2:
=IF($A2="","",VLOOKUP($A2,Sheet2!$A:$F,COLUMNS($A: A)+1,0))
Copy B2 across to F2, fill down as far as required
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"Jamie Thompson" wrote:
I am trying to figure out how to use some type of auto fill. What I have to
do is put in a customer name and then I need to have the address, city,
state, zip and phone number automatically fill in. How would I do that?
Reply With QuoteReply With Quote