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?

[TABLE="width: 128"]
<colgroup><col style="width:48pt" width="64" span="2"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 64"]Vendor #[/TD]
[TD="class: xl65, width: 64"]Tax ID[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]11111[/TD]
[TD="class: xl65, align: right"]201[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]22222[/TD]
[TD="class: xl65, align: right"]202[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]33333[/TD]
[TD="class: xl65, align: right"]203[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]12345[/TD]
[TD="class: xl65, align: right"]303[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]55555[/TD]
[TD="class: xl65, align: right"]404[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]66666[/TD]
[TD="class: xl65, align: right"]505[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]23456[/TD]
[TD="class: xl65, align: right"]606[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]34567[/TD]
[TD="class: xl65, align: right"]999[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]45678[/TD]
[TD="class: xl65, align: right"]1010[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]77777[/TD]
[TD="class: xl65, align: right"]1011[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]88888[/TD]
[TD="class: xl65, align: right"]1012[/TD]
[/TR]
</tbody>[/TABLE]


And, the VendorPmts is like this:

[TABLE="width: 128"]
<colgroup><col style="width:48pt" width="64" span="2"> </colgroup><tbody>[TR]
[TD="width: 64"]Vendor #[/TD]
[TD="width: 64"]Tax Id[/TD]
[/TR]
[TR]
[TD="align: right"]12345[/TD]
[TD="align: right"]303[/TD]
[/TR]
[TR]
[TD="align: right"]23456[/TD]
[TD="align: right"]606[/TD]
[/TR]
[TR]
[TD="align: right"]34567[/TD]
[TD="align: right"]999[/TD]
[/TR]
[TR]
[TD="align: right"]66666[/TD]
[TD="align: right"]505[/TD]
[/TR]
[TR]
[TD="align: right"]77777[/TD]
[TD="align: right"]1011[/TD]
[/TR]
</tbody>[/TABLE]

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

 

[Amandac6772]

Yes, I’ll try that.