Adding info from one sheet to another by matching vendor numbers

Amandac6772

New Member
Joined
Jun 16, 2011
Messages
32
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?
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
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.
 
Upvote 0
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.
 
Upvote 0
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)
 
Upvote 0

Forum statistics

Threads
1,224,818
Messages
6,181,151
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top