Related:
- Transfer data to match on Excel
- Free fire transfer - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Music match jukebox - Download - Audio playback
- Tmobile data check - Guide
- Number to words in excel - Guide
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
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.
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.
Dec 29, 2011 at 11:14 AM