+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Auto Fill in

  1. #1
    Registered User
    Join Date
    05-07-2010
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    2

    Cool Auto Fill in

    Hi,

    Here is what im needing. I would like to be able to place the company name in our excel purchase order and have the address & phone number fill itself in. Is there a formula for that? I have the company names and info in another workbook and have even copied them onto a sheet in the existing workbook.

    thanks!
    Darlene

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Auto Fill in Question

    There is more than one way to go about it. Perhaps the simplest is to use the VLOOKUP function in conjunction with the list you copied to the exisitng workbook.

    Assuming Sheet2 holds the list as follows in these cells:
    A1:A10 = Company name
    B1:B10 = Address
    C1:C10 = Phone number

    On Sheet1 you would use a formula like this, assuming Cell A1 holds the company name you want to search on:

    To return the matching address
    =VLOOKUP(A1,Sheet2!$A$1:$C$10,2,0)

    To return the matching phone number
    =VLOOKUP(A1,Sheet2!$A$1:$C$10,3,0)

    See this link: Excel VLookup Function and VLookup Example
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

  3. #3
    Registered User
    Join Date
    05-07-2010
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Auto Fill in Question

    The VLOOKUP worked perfectly... thank you!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1