+ Reply to Thread
Results 1 to 5 of 5

Cross referencing 2 workbooks...

  1. #1
    Registered User
    Join Date
    07-23-2008
    Location
    CT
    Posts
    3

    Cross referencing 2 workbooks...

    I've been reading up on how to cross reference 2 workbooks, and I've concluded that I'll need to likely use the VLOOKUP function. However; my excel experience is fairly limited, I've only used it a little since college, and now I'm trying to set up a function at work to make my days a little easier.

    Essentially I'll have 2 workbooks that I need to cross reference by a policy number, this is one of two fields that will have the same data between the 2 sheets, and happens to be the more precise column to compare out of.

    One sheet will be policies that haven't paid, and the other will be a large database of addresses. My co-worker who is leaving in the next few weeks has been manually cross referencing between the 2 sheets each time he needs to do a mailing.

    What is the best way to set this up to pull the data and drop it into a brand new sheet using VLOOKUP?

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902
    Well, perhaps you should review Vlookup in Excel Help... it explains it well there.

    your formula would be something like:

    =Vlookup(A1,Sheet2!A:B,2,False)

    where A1 is the lookup policy number

    and Sheet2 contains table in A:B where column A has all policies and B has addresses to pull.
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    07-23-2008
    Location
    CT
    Posts
    3
    Quote Originally Posted by NBVC
    Well, perhaps you should review Vlookup in Excel Help... it explains it well there.

    your formula would be something like:

    =Vlookup(A1,Sheet2!A:B,2,False)

    where A1 is the lookup policy number

    and Sheet2 contains table in A:B where column A has all policies and B has addresses to pull.

    Okay, so I think I've got it somewhat, but what is the 2 for after A:B, ?

    I think this is whats throwing me off...

  4. #4
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902
    The 2 is the column index number... ie. is the column number within the range A:B to get the items of interest from... so basically it refers to column B in this example.

  5. #5
    Registered User
    Join Date
    07-23-2008
    Location
    CT
    Posts
    3
    Quote Originally Posted by NBVC
    The 2 is the column index number... ie. is the column number within the range A:B to get the items of interest from... so basically it refers to column B in this example.

    ahh, okay, I got it now. 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