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

Willowdale

New Member
Joined
May 28, 2017
Messages
10
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.
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

maabadi

Well-known Member
Joined
Oct 22, 2012
Messages
1,032
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
9,986
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,861
Messages
5,574,709
Members
412,613
Latest member
EFRATA
Top