Transfer data to match on Excel

Closed
Dan - Dec 28, 2011 at 06:04 PM
 Dan - Dec 29, 2011 at 11:14 AM
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 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Dec 29, 2011 at 02:42 AM
"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.
0
No, these are two individual reports.
0