Two Vlookup and provide total of given account number

B

bhatipuru

New Member
Joined
Jun 25, 2012
Messages
20
Data
[TABLE="width: 384"]
<TBODY>[TR]
[TD="align: right"]10/01/12</SPAN>[/TD]
[TD="align: right"]2000</SPAN>[/TD]
[TD="align: right"]3000</SPAN>[/TD]
[TD="align: right"]4000</SPAN>[/TD]
[TD="align: right"]5000</SPAN>[/TD]
[TD="align: right"]6000</SPAN>[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1A</SPAN>[/TD]
[TD] 1.00 </SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]2A</SPAN>[/TD]
[TD][/TD]
[TD] 2.00 </SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3A</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD] 3.00 </SPAN>[/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4A</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] 4.00 </SPAN>[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]5A</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] 5.00 </SPAN>[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Totals</SPAN>[/TD]
[TD] 1.00 </SPAN></SPAN>[/TD]
[TD] 2.00 </SPAN></SPAN>[/TD]
[TD] 3.00 </SPAN></SPAN>[/TD]
[TD] 4.00 </SPAN></SPAN>[/TD]
[TD] 5.00 </SPAN>[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]10/01/12</SPAN>[/TD]
[TD="align: right"]2000</SPAN>[/TD]
[TD="align: right"]3000</SPAN>[/TD]
[TD="align: right"]4000</SPAN>[/TD]
[TD="align: right"]5000</SPAN>[/TD]
[TD="align: right"]6000</SPAN>[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1A</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]2A</SPAN>[/TD]
[TD][/TD]
[TD] 2.00 </SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3A</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4A</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] 4.00 </SPAN>[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]5A</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] 5.00 </SPAN>[/TD]
[/TR]
[TR]
[TD]6A</SPAN>[/TD]
[TD] 6.00 </SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Totals</SPAN>[/TD]
[TD] 6.00 </SPAN></SPAN>[/TD]
[TD] 2.00 </SPAN></SPAN>[/TD]
[TD] - </SPAN></SPAN>[/TD]
[TD] 4.00 </SPAN></SPAN>[/TD]
[TD] 5.00 </SPAN>[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]10/01/12</SPAN>[/TD]
[TD="align: right"]2000</SPAN>[/TD]
[TD="align: right"]3000</SPAN>[/TD]
[TD="align: right"]4000</SPAN>[/TD]
[TD="align: right"]5000</SPAN>[/TD]
[TD="align: right"]6000</SPAN>[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1A</SPAN>[/TD]
[TD] 1.00 </SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]2A</SPAN>[/TD]
[TD][/TD]
[TD] 2.00 </SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3A</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD] - </SPAN>[/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4A</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] - </SPAN>[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]5A</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] - </SPAN>[/TD]
[/TR]
[TR]
[TD]6A</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] 6.00 </SPAN>[/TD]
[/TR]
[TR]
[TD]7A</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD] 7.00 </SPAN>[/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Totals</SPAN>[/TD]
[TD] 1.00 </SPAN></SPAN>[/TD]
[TD] 2.00 </SPAN></SPAN>[/TD]
[TD] 7.00 </SPAN></SPAN>[/TD]
[TD] - </SPAN></SPAN>[/TD]
[TD] 6.00 </SPAN>[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]10/01/12</SPAN>[/TD]
[TD="align: right"]2000</SPAN>[/TD]
[TD="align: right"]3000</SPAN>[/TD]
[TD="align: right"]4000</SPAN>[/TD]
[TD="align: right"]5000</SPAN>[/TD]
[TD="align: right"]6000</SPAN>[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1A</SPAN>[/TD]
[TD] 1.00 </SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]2A</SPAN>[/TD]
[TD][/TD]
[TD] - </SPAN>[/TD]
[TD][/TD]
[TD] 2.00 </SPAN>[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3A</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD] - </SPAN>[/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4A</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] - </SPAN>[/TD]
[TD] 4.00 </SPAN>[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Totals</SPAN>[/TD]
[TD] 1.00 </SPAN></SPAN>[/TD]
[TD] - </SPAN></SPAN>[/TD]
[TD] - </SPAN></SPAN>[/TD]
[TD] 2.00 </SPAN></SPAN>[/TD]
[TD] 4.00 </SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL span=6></COLGROUP>[/TABLE]



New worksheet
[TABLE="width: 128"]
<TBODY>[TR]
[TD]Date</SPAN>[/TD]
[TD="align: right"]10/01/12</SPAN>[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2000</SPAN>[/TD]
[TD] 1.00 </SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]3000</SPAN>[/TD]
[TD] 2.00 </SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]4000</SPAN>[/TD]
[TD] 3.00 </SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]5000</SPAN>[/TD]
[TD] 4.00 </SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]6000</SPAN>[/TD]
[TD] 5.00 </SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL span=2></COLGROUP>[/TABLE]


What I want is, when I populate the date, the totals for 2000,3000 etc should give me the total for the account for the date. I need a formula
 
Sort by date Sort by votes
bhatipuru said:
Data
[TABLE="width: 384"]
<tbody>[TR]
[TD="align: right"]10/01/12[/TD]
[TD="align: right"]2000[/TD]
[TD="align: right"]3000[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]6000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1A[/TD]
[TD] 1.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2A[/TD]
[TD][/TD]
[TD] 2.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3A[/TD]
[TD][/TD]
[TD][/TD]
[TD] 3.00[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] 4.00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] 5.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Totals[/TD]
[TD] 1.00 [/TD]
[TD] 2.00 [/TD]
[TD] 3.00 [/TD]
[TD] 4.00 [/TD]
[TD] 5.00 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]10/01/12[/TD]
[TD="align: right"]2000[/TD]
[TD="align: right"]3000[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]6000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2A[/TD]
[TD][/TD]
[TD] 2.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] 4.00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] 5.00[/TD]
[/TR]
[TR]
[TD]6A[/TD]
[TD] 6.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Totals[/TD]
[TD] 6.00 [/TD]
[TD] 2.00 [/TD]
[TD] - [/TD]
[TD] 4.00 [/TD]
[TD] 5.00 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]10/01/12[/TD]
[TD="align: right"]2000[/TD]
[TD="align: right"]3000[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]6000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1A[/TD]
[TD] 1.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2A[/TD]
[TD][/TD]
[TD] 2.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3A[/TD]
[TD][/TD]
[TD][/TD]
[TD] -[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] -[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] -[/TD]
[/TR]
[TR]
[TD]6A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] 6.00[/TD]
[/TR]
[TR]
[TD]7A[/TD]
[TD][/TD]
[TD][/TD]
[TD] 7.00[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Totals[/TD]
[TD] 1.00 [/TD]
[TD] 2.00 [/TD]
[TD] 7.00 [/TD]
[TD] - [/TD]
[TD] 6.00 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]10/01/12[/TD]
[TD="align: right"]2000[/TD]
[TD="align: right"]3000[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]6000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1A[/TD]
[TD] 1.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2A[/TD]
[TD][/TD]
[TD] -[/TD]
[TD][/TD]
[TD] 2.00[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3A[/TD]
[TD][/TD]
[TD][/TD]
[TD] -[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] -[/TD]
[TD] 4.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Totals[/TD]
[TD] 1.00 [/TD]
[TD] - [/TD]
[TD] - [/TD]
[TD] 2.00 [/TD]
[TD] 4.00 [/TD]
[/TR]
</tbody>[/TABLE]



New worksheet
[TABLE="width: 128"]
<tbody>[TR]
[TD]Date[/TD]
[TD="align: right"]10/01/12[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2000[/TD]
[TD] 1.00[/TD]
[/TR]
[TR]
[TD="align: right"]3000[/TD]
[TD] 2.00[/TD]
[/TR]
[TR]
[TD="align: right"]4000[/TD]
[TD] 3.00[/TD]
[/TR]
[TR]
[TD="align: right"]5000[/TD]
[TD] 4.00[/TD]
[/TR]
[TR]
[TD="align: right"]6000[/TD]
[TD] 5.00[/TD]
[/TR]
</tbody>[/TABLE]


What I want is, when I populate the date, the totals for 2000,3000 etc should give me the total for the account for the date. I need a formula
Click to expand...

Are those -multiple table going down the sheet?
So the answer let say for 3000 will be 6?
 
Upvote 0
The answer I want is for 3000 is 2 for 10-01-12 and 10-04-12 (last table the date should be 10-04-12 instead of 10-01-12) = 0.
 
Upvote 0
bhatipuru said:
any update?
Click to expand...

Excel 2010
ABCDEF
Data
1A
2A
3A
4A
5A
Totals
1A
2A
3A
4A
5A
6A
Totals-
1A
2A
3A-
4A-
5A-
6A
7A
Totals-
1A
2A-
3A-
4A-
Totals--

<tbody>
[TD="align: center"]1[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]10/1/2012[/TD]
[TD="align: right"]2000[/TD]
[TD="align: right"]3000[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]6000[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]

[TD="align: right"][/TD]
[TD="align: right"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]3[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4[/TD]
[TD="align: right"][/TD]

[TD="align: center"]8[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]5[/TD]

[TD="align: center"]9[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]10[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]

[TD="align: center"]11[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]12[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]13[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]14[/TD]
[TD="align: right"]10/2/2012[/TD]
[TD="align: right"]2000[/TD]
[TD="align: right"]3000[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]6000[/TD]

[TD="align: center"]15[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]16[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]17[/TD]

[TD="align: right"][/TD]
[TD="align: right"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]18[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]19[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4[/TD]
[TD="align: right"][/TD]

[TD="align: center"]20[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]5[/TD]

[TD="align: center"]21[/TD]

[TD="align: right"]6[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]22[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]23[/TD]

[TD="align: right"]6[/TD]
[TD="align: right"]2[/TD]

[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]

[TD="align: center"]24[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]25[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]26[/TD]
[TD="align: right"]10/3/2012[/TD]
[TD="align: right"]2000[/TD]
[TD="align: right"]3000[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]6000[/TD]

[TD="align: center"]27[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]28[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]29[/TD]

[TD="align: right"][/TD]
[TD="align: right"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]30[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]31[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]32[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]33[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6[/TD]

[TD="align: center"]34[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]7[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]35[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]36[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]7[/TD]

[TD="align: right"]6[/TD]

[TD="align: center"]37[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]38[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]39[/TD]
[TD="align: right"]10/4/2012[/TD]
[TD="align: right"]2000[/TD]
[TD="align: right"]3000[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]6000[/TD]

[TD="align: center"]40[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]41[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]42[/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"]2[/TD]
[TD="align: right"][/TD]

[TD="align: center"]43[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]44[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]4[/TD]

[TD="align: center"]45[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]46[/TD]

[TD="align: right"]5555[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]

</tbody>
Sheet1​

Excel 2010
AB
Date
totals
-
-

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: right"]10/4/2012[/TD]

[TD="align: center"]2[/TD]

[TD="align: right"][/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]2000[/TD]
[TD="align: right"]5555[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]3000[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]4000[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]2[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]6000[/TD]
[TD="align: right"]4[/TD]

</tbody>
Sheet2​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B3[/TH]
[TD="align: left"]=INDEX(Sheet1!$A$100:OFFSET(Sheet1!$A$2,MATCH($B$1,Sheet1!$A$2:$A$100,0)-1,6,,),MATCH($A$2,INDEX(Sheet1!$A$100:OFFSET(Sheet1!$A$2,MATCH($B$1,Sheet1!$A$2:$A$100,0)-1,,,),),0),MATCH($A3,INDEX(Sheet1!$A$2:$F$100,MATCH($B$1,Sheet1!$A$2:$A$100,0),0),0))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
You must log in or register to reply here.

Similar threads

H
  • Question Question
multiple criteria Costing
Replies
6
Views
169
harky
H
A
  • Solved
Compare two sheets based on lastrow with highlighted cells
2 3
Replies
26
Views
482
mumps
mumps
A
  • Solved
Multiple columns to populate data on userform based on header in combobox
Replies
4
Views
159
abdo meghari
A
A
  • Solved
Create accounts by user form to show balance by calculation for two columns
Replies
4
Views
177
abdo meghari
A
A
  • Solved
Add elements for adjacent cells by insert column based on multiple characters
2
Replies
17
Views
703
felixstraube
F

Forum statistics

Threads
1,226,849
Messages
6,193,330
Members
453,790
Latest member
yassinosnoo1

Share this page

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
Back
Top