How do I use auto fill to add information from an existing source?

  • Thread starter Thread starter Jamie Thompson
  • Start date Start date
J

Jamie Thompson

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?
 
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
 
Back
Top