Results 1 to 2 of 2

Thread: Auto Fill, Excel 2010

  1. 2013-07-11, 07:12 PM #1
    msmonicadoll
    msmonicadoll is offline
    Neophyte msmonicadoll's Avatar
    Join Date
    Jul 2013
    Posts
    1
    Articles
    0

    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!
    Reply With Quote Reply With Quote
  2. 2013-07-11, 09:00 PM #2
    NBVC
    NBVC is offline
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,508
    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.

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

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

Forum Rules

Gravatar by 1e2.it