Results 1 to 2 of 2

Thread: Auto Fill, Excel 2010

  1. #1

    Auto Fill, Excel 2010



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Click image for larger version. 

Name:	How to Auto Fill_Page_1.jpg 
Views:	16 
Size:	79.8 KB 
ID:	1482Hello, I have included an image of what I would like to accomplish. Thank you!

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Use VLOOKUP

    e.g

    Code:
    =VLOOKUP(A4,'Sheet2'!A:D,2,0)
    to get phone #

    Code:
    =VLOOKUP(A4,'Sheet2'!A:D,3,0)
    to get address 1

    Code:
    =VLOOKUP(A4,'Sheet2'!A:D,4,0)
    to get address 2

    where A4 contains the typed person's name, and Sheet2, columns A: D contain the database to look up.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •