Results 1 to 5 of 5

Thread: Adding info from one sheet to another by matching vendor numbers
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jun 2011
    Posts
    28
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Adding info from one sheet to another by matching vendor numbers

    I have two sheets of data. One is vendor payments, the other general vendor data from their master file. I need to add their federal tax id to the vendor payment sheet by matching the vendor numbers on each sheet. What’s the best way to do this?

  2. #2
    Board Regular kweaver's Avatar
    Join Date
    May 2018
    Location
    La Jolla, CA
    Posts
    629
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Adding info from one sheet to another by matching vendor numbers

    This is difficult to show you without seeing specifics, like some row and column data and where you want the result. It's most likely a VLOOKUP, but that's an uninformed guess.

  3. #3
    New Member
    Join Date
    Jun 2011
    Posts
    28
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Adding info from one sheet to another by matching vendor numbers

    I’m thinking vlookup too. So let’s say the vendor number is in A1 on both sheets and I want the tax ID from sheet 2 in B2 on sheet 1 but that info is somewhere in the column b2:b99 on sheet 2. I need it to match up to the vendor number then look in b2:b99 for the correct tax id.

  4. #4
    Board Regular kweaver's Avatar
    Join Date
    May 2018
    Location
    La Jolla, CA
    Posts
    629
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Adding info from one sheet to another by matching vendor numbers

    So, maybe the vendor data looks like like this?

    Vendor # Tax ID
    11111 201
    22222 202
    33333 203
    12345 303
    55555 404
    66666 505
    23456 606
    34567 999
    45678 1010
    77777 1011
    88888 1012


    And, the VendorPmts is like this:

    Vendor # Tax Id
    12345 303
    23456 606
    34567 999
    66666 505
    77777 1011

    With B2 filled down: =VLOOKUP(A2,VenderData!$A$2:$B$100,2,FALSE)

  5. #5
    New Member
    Join Date
    Jun 2011
    Posts
    28
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Adding info from one sheet to another by matching vendor numbers

    Yes, I’ll try that.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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