Compare account numbers in two sheets and grab extra data to the right

Willowdale

New Member
Joined
May 28, 2017
Messages
14
Greetings.

Im not sure how to do this, but Im sure its a lay-up for many here.

Im thinking : compare, vlookup, index/match or conditional formatting or some combination thereof.

Issue:

I can export a csv file that has a set of customer records; names, acct numbers etc, and it has some of the info i want in, say columns A thru H.
Lets call this the target set.

I can export another csv file that has extra data in additional columns, lets say I thru P attached to the many, if not all, of the same customer records, but its in a different sheet.

What id like to do is look at the account number column on target set, and if that account number is present on the sheet with the extra data, to then take and copy that extra data back to the sheet with the target set, essentially matching the extra data to each specific account number.

Bottom line: My target set lacks some additional data in columns that i'd like appended to the right of the existing data on a per account number basis.

I hope Im clear with this.
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

maabadi

Well-known Member
Joined
Oct 22, 2012
Messages
2,681
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
Please upload one file with 4-5 rows as example. & please use XL2BB.
 

mumps

Well-known Member
Joined
Apr 11, 2012
Messages
10,843
Office Version
  1. 2013
  2. 2010
Platform
  1. Windows
In which column is the account number in the target set and in which column is the account number in the sheet with the extra data in additional columns? What are the names of those two sheets?
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,194
Messages
5,768,776
Members
425,492
Latest member
blueexcel123

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
Top