Transfer data to match on Excel [Closed]

Report
-
 Dan -
I have two reports. One is from 2010, the other is from 2011. Within each report is the same information...account numbers, member names, credit scores, etc. I need to transfer the credit scores from the 2010 report and add them to the 2011 report, the catch is I need to have them aligned with the appropriate account number. The account numbers are located in column "A", the credit scores are located in column "L". I want to create a new column ("M") in the 2011 report showing the 2010 credit scores. How can I do this? Please help.



1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
797
"I have two reports. One is from 2010, the other is from 2011"
does it mean 2010 data is in sheet1 and 2011 data is in sheet2
In sheet1
type in A1 acct no.
in A2 type 111
in L1 type 2010
in sheet2
type in A1 acct no.
in A2 type 111
in L1 type 2011

in sheet 1 in M2 type this formula

=VLOOKUP(A2,Sheet2!$A$1:$L$100,COLUMN($L$1),0)

if more data is there both in sheet 1 and sheet 2 the formula in sheet 1 M2 can be copied down.
No, these are two individual reports.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!