Adding info from one sheet to another by matching vendor numbers

[Amandac6772]

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?

 

[kweaver]

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.

 

[Amandac6772]

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.

 

[kweaver]

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

<colgroup><col style="width:48pt" width="64" span="2"> </colgroup><tbody>
</tbody>

And, the VendorPmts is like this:

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

<colgroup><col style="width:48pt" width="64" span="2"> </colgroup><tbody>
</tbody>

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

 

[Amandac6772]

Yes, I’ll try that.