Lookup for Horizontal and Vertical Search

[khawarameer]

Dear All,

I have two tables, in table 1 i have a statement of more than one customers combined in sequential order, in table 2 i have customer numbers vertically placed and dates horizontally placed. i want to use a lookup function which may extract day end balance in front of each account under dates mention in horizontal column, i have use lookup function for single search but for such multiple i need help.

here are the tables.

Customer #	Date	Debit	Credit	Balance		Customer	01/03/2013	02/03/2013	03/03/2013	04/03/2013	05/03/2013	06/03/2013	07/03/2013	08/03/2013	09/03/2013	10/03/2013	11/03/2013	12/03/2013	13/03/2013	14/03/2013	15/03/2013	16/03/2013	17/03/2013	18/03/2013	19/03/2013	20/03/2013	21/03/2013	22/03/2013	23/03/2013	24/03/2013	25/03/2013	26/03/2013	27/03/2013	28/03/2013	29/03/2013	30/03/2013	31/03/2013
58835905703901	07/03/2013		59.74	10,212.51		58835907977301
58835905703901	07/03/2013	5.97		10,206.54		58835907977301
58835905703901	20/03/2013		50,000.00	60,206.54		58835907977301
58835905703901	25/03/2013	30,000.00		30,206.54		58835907977301
58835907977301	01/03/2013		100,000.00	911,383.79		58835907977301
58835907977301	06/03/2013	200,000.00		711,383.79		58835907977301
58835907977301	06/03/2013	100,000.00		611,383.79		58835907977301
58835907977301	06/03/2013	211,383.00		400,000.79		58835907977301
58835907977301	06/03/2013	100,000.00		300,000.79		58835907977301
58835907977301	06/03/2013	100,000.00		200,000.79		58835913797701
58835907977301	06/03/2013	100,000.00		100,000.79		58835913797701
58835907977301	06/03/2013	100,000.00		0.79		58835913797701
58835907977301	07/03/2013		2,785.15	2,785.94		58835913797701
58835907977301	07/03/2013	278.52		2,507.42		58835913797701
58835911880901	22/03/2013		10,000.00	10,000.00		58835913797701
58835912717701	07/03/2013		4,708.87	805,014.36		58835921343401
58835912717701	07/03/2013	470.89		804,543.47		58835921343401
58835912717701	14/03/2013	10,230.00		794,313.47		58835921343401
58835912717701	14/03/2013		24,000.00	818,313.47		58835921394301
58835912717701	15/03/2013	8,065.00		810,248.47		58835921394301
58835912717701	25/03/2013	7,300.00		802,948.47		58835921394301
58835912717701	25/03/2013	3,200.00		799,748.47		58835921409301
58835912717701	27/03/2013	6,700.00		793,048.47		58835921409301
58835912717701	28/03/2013	11,000.01		782,048.46		58835921461301
58835913797701	05/03/2013	30,000.00		1,474,092.49		58835921461301
58835913797701	07/03/2013	229,000.00		1,245,092.49		58835921461301
58835913797701	07/03/2013		2,269.29	1,247,361.78		58835921461301
58835913797701	07/03/2013	226.93		1,247,134.85		58835921476801
58835913797701	08/03/2013		25,000.00	1,272,134.85		58835921491301
58835913797701	08/03/2013	30,000.00		1,242,134.85		58835921491301
58835913797701	08/03/2013	30,000.00		1,212,134.85		58835921502201
58835913797701	11/03/2013		200,000.00	1,412,134.85		58835921502201
58835913797701	11/03/2013	44,800.00		1,367,334.85		58835921502201
58835913797701	15/03/2013	25,000.00		1,342,334.85		58835921502201
58835913797701	18/03/2013		29,400.00	1,371,734.85		58835921502201
58835913797701	18/03/2013		400,000.00	1,771,734.85		58835921502201
58835913797701	20/03/2013	30,000.00		1,741,734.85		58835921502201
58835913797701	20/03/2013	25,000.00		1,716,734.85		58835921502201
58835913797701	25/03/2013	60,000.00		1,656,734.85		58835921502201
58835913797701	25/03/2013	120.00		1,656,614.85		58835921502201
58835913797701	26/03/2013	25,000.00		1,631,614.85		58835921502201
58835913797701	28/03/2013	44,800.00		1,586,814.85		58835921502201
58835913797701	28/03/2013	100,000.00		1,486,814.85		58835921502201
58835913797701	28/03/2013	100,000.00		1,386,814.85		58835921538601
58835913797701	28/03/2013	200.00		1,386,614.85		58835921571501
58835919911701	06/03/2013	40,000.00		684,885.53		58835921571501
58835919911701	07/03/2013		6,176.01	691,061.54		58835921571501
58835919911701	07/03/2013	617.60		690,443.94		58835921571501
58835919911701	08/03/2013	300,000.00		390,443.94		58835921571501
58835919911701	08/03/2013	600.00		389,843.94		58835921571501
58835919911701	08/03/2013	2,500.00		387,343.94		58835921571501
58835919911701	08/03/2013	3,480.00		383,863.94		58835921571501
58835919911701	09/03/2013	90,000.00		293,863.94		58835921571501
58835919911701	09/03/2013	180.00		293,683.94		58835921571501
58835919911701	11/03/2013	100,000.00		193,683.94		58835921578201
58835919911701	11/03/2013	200.00		193,483.94		58835921578201
58835919911701	15/03/2013	50,000.00		143,483.94		58835921578201
58835919911701	22/03/2013	60,000.00		83,483.94		58835921578201
58835919911701	22/03/2013	120.00		83,363.94		58835921578201
58835921323101	07/03/2013		239.40	40,926.74		58835921578201
58835921323101	07/03/2013	23.94		40,902.80		58835921578201
58835921323101	25/03/2013		24,000.00	64,902.80		58835921578201
58835921341701	01/03/2013		350,000.00	2,398,819.20		58835921578201
58835921341701	07/03/2013		11,654.39	2,410,473.59		58835921612301
58835921341701	07/03/2013	1,165.44		2,409,308.15		58835921612301
58835921341701	16/03/2013	1,000.00		2,408,308.15		58835921657601
58835921341701	29/03/2013		290,000.00	2,698,308.15		58835921792801
58835921343401	01/03/2013	50,000.00		77,214.76		58835921792801
58835921343401	07/03/2013		623.48	77,838.24		58835921797501
58835921343401	07/03/2013	62.35		77,775.89		58835921797501
58835921343401	11/03/2013		25,000.00	102,775.89		58835921870601
58835921343401	12/03/2013		10,000.00	112,775.89		58835921883401
58835921343401	16/03/2013		30,000.00	142,775.89		58835921994601
58835921343401	19/03/2013		40,000.00	182,775.89		58835922025301
58835921343401	29/03/2013	15,000.00		167,775.89		58835922025301
58835921343401	30/03/2013	25,000.00		142,775.89		58835922035301
58835921347301	05/03/2013	3,000.00		206,926.70		58835922035801
58835921347301	05/03/2013	17.40		206,909.30		58835922035801
58835921347301	06/03/2013	605.00		206,304.30		58835922141901
58835921347301	07/03/2013	3,000.00		203,304.30		58835922196201
58835921347301	07/03/2013		1,358.79	204,663.09		58835922232601
58835921347301	07/03/2013	135.88		204,527.21		58835922232601
58835921347301	09/03/2013	2,000.00		202,527.21		58835922232601
58835921347301	09/03/2013	17.40		202,509.81		58835922232601
58835921347301	09/03/2013	995.00		201,514.81		58835922232601
58835921347301	11/03/2013	4,999.99		196,514.82		58835922232601
58835921347301	16/03/2013	503.00		196,011.82		58835922232601
58835921347301	21/03/2013	1,289.00		194,722.82		58835922232601
58835921347301	25/03/2013	449.00		194,273.82		58835922232601
58835921347301	26/03/2013	430.00		193,843.82		58835922232601
58835921347301	28/03/2013	1,000.00		192,843.82		58835922232601
58835921347301	29/03/2013	1,000.00		191,843.82		58835922232601
58835921352001	02/03/2013	26,000.00		33,073.56		58835922232601
58835921352001	06/03/2013		29,000.00	62,073.56		58835922232601
58835921352001	07/03/2013		334.55	62,408.11		58835922235101
58835921352001	07/03/2013	33.46		62,374.65		58835922235101
58835921352001	16/03/2013		3,500.00	65,874.65		58835922304701
58835921352001	18/03/2013	20,000.00		45,874.65		58835922304701
58835921352001	18/03/2013	17.40		45,857.25		58835922304701
58835921352001	18/03/2013	10,000.00		35,857.25		58835922304701
58835921352001	18/03/2013	17.40		35,839.85		58835922304701
58835921352001	18/03/2013	5,000.00		30,839.85		58835922837501
58835921352001	18/03/2013	17.40		30,822.45		58835922837501
58835921382801	05/03/2013		30,000.00	532,294.73		58835922837501
58835921382801	07/03/2013		2,804.12	535,098.85		58835922837501
58835921382801	07/03/2013	280.41		534,818.44		58835922837501
58835921382801	08/03/2013	20,000.00		514,818.44		58835922837501
58835921382801	18/03/2013		4,000.00	518,818.44		58835922837501
58835921391901	02/03/2013		200.00	604,206.33		58835922837501
58835921391901	02/03/2013	604,006.00		200.33		58835922837501
58835921391901	07/03/2013		3,545.79	3,746.12
58835921391901	07/03/2013	354.58		3,391.54
58835921391901	20/03/2013	3,000.00		391.54
58835921392301	07/03/2013		77.60	10,231.33
58835921392301	07/03/2013	7.76		10,223.57
58835921394301	07/03/2013		162.35	25,290.51
58835921394301	07/03/2013	16.24		25,274.27
58835921409301	05/03/2013	138,000.00		10,636.09
58835921409301	07/03/2013		530.35	11,166.44
58835921409301	07/03/2013	53.04		11,113.40
58835921409301	08/03/2013		178,000.00	189,113.40
58835921409301	12/03/2013	178,000.00		11,113.40
58835921426001	07/03/2013		11,996.93	2,142,174.92
58835921426001	07/03/2013	1,199.69		2,140,975.23
58835921449601	07/03/2013		59.66	10,199.71
58835921449601	07/03/2013	5.97		10,193.74
58835921449601	22/03/2013		100,000.00	110,193.74
58835921461301	07/03/2013	6,378.00		34,037.76
58835921461301	07/03/2013		294.59	34,332.35
58835921461301	07/03/2013	29.46		34,302.89
58835921461301	13/03/2013	14,000.00		20,302.89
58835921461301	14/03/2013		90,000.00	110,302.89
58835921463801	07/03/2013		59.65	10,197.59
58835921463801	07/03/2013	5.96		10,191.63
58835921476801	07/03/2013		123.17	30,342.15
58835921476801	07/03/2013	12.32		30,329.83
58835921476801	20/03/2013	15,000.00		15,329.83
58835921477201	07/03/2013		3,443.77	588,737.69
58835921477201	07/03/2013	344.38		588,393.31
58835921490301	07/03/2013		327.81	96,756.36
58835921490301	07/03/2013	32.78		96,723.58
58835921490301	19/03/2013		8,000.00	104,723.58
58835921490301	20/03/2013		192,000.00	296,723.58
58835921491301	07/03/2013		152.45	26,062.54
58835921491301	07/03/2013	15.24		26,047.30
58835921491301	11/03/2013	20,000.00		6,047.30
58835921492001	07/03/2013		653.59	111,735.75
58835921492001	07/03/2013	65.36		111,670.39
58835921492001	29/03/2013		10,000.00	121,670.39
58835921502201	01/03/2013	20,000.00		1,821,661.62
58835921502201	01/03/2013	20,000.00		1,801,661.62
58835921502201	01/03/2013	10,000.00		1,791,661.62
58835921502201	01/03/2013	300.00		1,791,361.62
58835921502201	05/03/2013	50,000.00		1,741,361.62
58835921502201	06/03/2013	83,000.00		1,658,361.62
58835921502201	07/03/2013		7,763.46	1,666,125.08
58835921502201	07/03/2013	776.35		1,665,348.73
58835921502201	08/03/2013	295,000.00		1,370,348.73
58835921502201	14/03/2013	829,000.00		541,348.73
58835921502201	16/03/2013	10,000.00		531,348.73
58835921502201	16/03/2013	10,000.00		521,348.73
58835921502201	16/03/2013	10,000.00		511,348.73
58835921502201	16/03/2013	10,000.00		501,348.73
58835921502201	16/03/2013	10,000.00		491,348.73
58835921502201	28/03/2013		800,000.00	1,291,348.73
58835921502201	28/03/2013		2,008,077.00	3,299,425.73
58835921502201	29/03/2013	1,000,000.00		2,299,425.73
58835921502201	29/03/2013	34,500.00		2,264,925.73
58835921506001	07/03/2013		139.59	28,327.99
58835921506001	07/03/2013	13.96		28,314.03
58835921506001	18/03/2013		15,000.00	43,314.03
58835921506001	30/03/2013	3,000.00		40,314.03
58835921538601	07/03/2013		3,129.55	533,176.24
58835921538601	07/03/2013	312.96		532,863.28
58835921538601	08/03/2013	2,800.00		530,063.28
58835921545301	07/03/2013		8,902.02	1,508,902.53
58835921545301	07/03/2013	890.20		1,508,012.33
58835921557701	07/03/2013		142.12	20,322.66
58835921557701	07/03/2013	14.21		20,308.45
58835921557701	11/03/2013	7,000.00		13,308.45
58835921557701	16/03/2013	3,000.00		10,308.45
58835921557701	27/03/2013		12,000.00	22,308.45
58835921557701	29/03/2013		40,000.00	62,308.45
58835921571501	07/03/2013		19,849.95	3,421,557.79
58835921571501	07/03/2013	1,985.00		3,419,572.79
58835921571501	08/03/2013	2,000.00		3,417,572.79
58835921571501	11/03/2013	26,511.00		3,391,061.79
58835921571501	12/03/2013	10,000.00		3,381,061.79
58835921571501	13/03/2013	4,000.00		3,377,061.79
58835921571501	15/03/2013	2,000.00		3,375,061.79
58835921571501	19/03/2013	3,000.00		3,372,061.79
58835921571501	19/03/2013	15,000.00		3,357,061.79
58835921571501	20/03/2013		50,000.00	3,407,061.79
58835921571501	22/03/2013		186,565.00	3,593,626.79
58835921571501	22/03/2013	50,000.00		3,543,626.79
58835921571501	27/03/2013	100,000.00		3,443,626.79
58835921571501	28/03/2013	20,000.00		3,423,626.79
58835921571501	29/03/2013	5,000.00		3,418,626.79
58835921578201	01/03/2013	5,000.00		649,027.70
58835921578201	05/03/2013	10,000.00		639,027.70
58835921578201	06/03/2013	15,000.00		624,027.70
58835921578201	07/03/2013		3,643.42	627,671.12
58835921578201	07/03/2013	364.34		627,306.78
58835921578201	08/03/2013	50,000.00		577,306.78
58835921578201	11/03/2013	55,000.00		522,306.78
58835921578201	11/03/2013	110.00		522,196.78
58835921578201	14/03/2013	5,000.00		517,196.78
58835921578201	16/03/2013	5,000.00		512,196.78
58835921578201	21/03/2013	10,000.00		502,196.78
58835921578201	21/03/2013	150.00		502,046.78
58835921578201	25/03/2013	10,000.00		492,046.78
58835921578201	25/03/2013	5,000.00		487,046.78
58835921612301	07/03/2013		2,956.21	644,670.91
58835921612301	07/03/2013	295.62		644,375.29
58835921612301	20/03/2013		46,000.00	690,375.29
58835921612301	20/03/2013	400,000.00		290,375.29
58835921612301	22/03/2013		100,000.00	390,375.29
58835921612301	22/03/2013		400,000.00	790,375.29
58835921612301	22/03/2013		20,000.00	810,375.29
58835921614701	07/03/2013		10,000.00	448,528.23
58835921614701	07/03/2013		2,449.94	450,978.17
58835921614701	07/03/2013	244.99		450,733.18
58835921614701	08/03/2013	3,000.00		447,733.18
58835921614701	12/03/2013	41.00		447,692.18
58835921614701	19/03/2013		430,000.00	877,692.18
58835921614701	21/03/2013		20,000.00	897,692.18
58835921614701	22/03/2013	4,000.00		893,692.18
58835921614701	26/03/2013		10,000.00	903,692.18
58835921614701	28/03/2013	3,000.00		900,692.18
58835921614701	28/03/2013	2,000.00		898,692.18
58835921614701	28/03/2013	3,480.00		895,212.18
58835921626101	07/03/2013		269.23	49,351.87
58835921626101	07/03/2013	26.92		49,324.95
58835921626101	08/03/2013	2,000.00		47,324.95
58835921626101	08/03/2013	17.40		47,307.55
58835921626101	11/03/2013		20,460.00	67,767.55
58835921626101	11/03/2013	2,000.00		65,767.55
58835921637201	07/03/2013		59.36	10,148.39
58835921637201	07/03/2013	5.94		10,142.45
58835921657601	07/03/2013		20,745.65	3,546,617.28
58835921657601	07/03/2013	2,074.56		3,544,542.72
58835921657601	27/03/2013	357,000.00		3,187,542.72
58835921666401	07/03/2013		415.24	70,988.70
58835921666401	07/03/2013	41.52		70,947.18
58835921666401	20/03/2013	30,000.00		40,947.18
58835921666401	21/03/2013		30,000.00	70,947.18
58835921666401	26/03/2013	10,000.00		60,947.18
58835921702801	04/03/2013		50,000.00	151,199.54
58835921702801	05/03/2013	50,000.00		101,199.54
58835921702801	05/03/2013	30,000.00		71,199.54
58835921702801	05/03/2013		50,000.00	121,199.54
58835921702801	06/03/2013		47,000.00	168,199.54
58835921702801	07/03/2013		454.65	168,654.19
58835921702801	07/03/2013	45.46		168,608.73
58835921702801	12/03/2013	15,400.00		153,208.73
58835921702801	18/03/2013		40,000.00	193,208.73
58835921792801	07/03/2013		3,462.66	656,252.14
58835921792801	07/03/2013	346.27		655,905.87
58835921797501	04/03/2013		25,000.00	100,678.15
58835921797501	05/03/2013	25,000.00		75,678.15
58835921797501	05/03/2013		25,000.00	100,678.15
58835921797501	05/03/2013		25,000.00	125,678.15
58835921797501	06/03/2013	50,000.00		75,678.15
58835921797501	07/03/2013		16,000.00	91,678.15
58835921797501	07/03/2013		761.11	92,439.26
58835921797501	07/03/2013	76.11		92,363.15
58835921797501	12/03/2013		35,000.00	127,363.15
58835921797501	12/03/2013	12,675.00		114,688.15
58835921797501	13/03/2013		2,900.00	117,588.15
58835921797501	13/03/2013	50,000.00		67,588.15
58835921797501	15/03/2013		30,000.00	97,588.15
58835921797501	16/03/2013	30,000.00		67,588.15
58835921797501	16/03/2013	10,000.00		57,588.15
58835921797501	22/03/2013		1,000.00	58,588.15
58835921797501	22/03/2013		12,500.00	71,088.15
58835921797501	25/03/2013		30,000.00	101,088.15
58835921797501	25/03/2013	30,000.00		71,088.15
58835921846701	07/03/2013		2,444.26	514,292.94
58835921846701	07/03/2013	244.43		514,048.51
58835921883401	07/03/2013		1,178.83	34,424.21
58835921883401	07/03/2013	117.88		34,306.33
58835921886101	07/03/2013		680.88	116,400.87
58835921886101	07/03/2013	68.09		116,332.78
58835921886101	11/03/2013		35,000.00	151,332.78
58835921886101	25/03/2013		15,000.00	166,332.78
58835921890201	07/03/2013		349.60	60,466.72
58835921890201	07/03/2013	34.96		60,431.76
58835921890201	26/03/2013	5,000.00		55,431.76
58835921890201	26/03/2013	17.40		55,414.36
58835921956001	07/03/2013		88.02	17,119.21
58835921956001	07/03/2013	8.80		17,110.41
58835921956001	15/03/2013		14,000.00	31,110.41
58835921956001	20/03/2013		7,000.00	38,110.41
58835921960601	01/03/2013		10,000.00	56,687.09
58835921960601	05/03/2013	5,000.00		51,687.09
58835921960601	06/03/2013		25,000.00	76,687.09
58835921960601	07/03/2013		341.06	77,028.15
58835921960601	07/03/2013	34.11		76,994.04
58835921960601	08/03/2013	5,000.00		71,994.04
58835921960601	15/03/2013		10,000.00	81,994.04
58835921960601	16/03/2013	10,000.00		71,994.04
58835921960601	19/03/2013		10,000.00	81,994.04
58835921960601	19/03/2013		10,000.00	91,994.04
58835921960601	22/03/2013	5,000.00		86,994.04
58835921960601	25/03/2013	10,000.00		76,994.04
58835921963001	07/03/2013		59.02	10,090.21
58835921963001	07/03/2013	5.90		10,084.31
58835921978401	07/03/2013		12,314.43	2,120,025.72
58835921978401	07/03/2013	1,231.44		2,118,794.28
58835921978401	12/03/2013		40,000.00	2,158,794.28
58835921978401	19/03/2013		23,000.00	2,181,794.28
58835921978801	07/03/2013		183.21	31,321.22
58835921978801	07/03/2013	18.32		31,302.90
58835921988801	07/03/2013		3,007.17	514,096.93
58835921988801	07/03/2013	300.72		513,796.21
58835921994601	07/03/2013		100,000.00	115,247.76
58835921994601	07/03/2013		184.28	115,432.04
58835921994601	07/03/2013	18.43		115,413.61
58835921994601	16/03/2013	14,100.00		101,313.61
58835921994601	19/03/2013	25,000.00		76,313.61
58835921994601	22/03/2013	5,000.00		71,313.61
58835921994601	22/03/2013	17.40		71,296.21
58835921994601	25/03/2013	20,000.00		51,296.21
58835921994601	25/03/2013	17.40		51,278.81
58835921994601	27/03/2013	10,000.00		41,278.81
58835921994601	27/03/2013	17.40		41,261.41
58835922025301	07/03/2013		10,022.49	1,081,410.02
58835922025301	07/03/2013	1,002.25		1,080,407.77
58835922035301	05/03/2013		168,000.00	178,023.39
58835922035301	07/03/2013	9,000.00		169,023.39
58835922035301	07/03/2013		58.98	169,082.37
58835922035301	07/03/2013	5.90		169,076.47
58835922035301	11/03/2013	159,000.00		10,076.47
58835922035801	07/03/2013		1,709.84	292,309.88
58835922035801	07/03/2013	170.98		292,138.90
58835922035801	11/03/2013	50,000.00		242,138.90
58835922035801	11/03/2013	30,000.00		212,138.90
58835922035801	12/03/2013	75,000.00		137,138.90
58835922035801	15/03/2013		80,000.00	217,138.90
58835922035801	19/03/2013	17,982.00		199,156.90
58835922035801	25/03/2013	10,000.00		189,156.90
58835922035801	26/03/2013		100,000.00	289,156.90
58835922035801	26/03/2013	100,000.00		189,156.90
58835922035801	28/03/2013	3,100.00		186,056.90
58835922036901	07/03/2013		4,188.43	716,042.75
58835922036901	07/03/2013	418.84		715,623.91
58835922037701	02/03/2013	1,000.00		3,015.72
58835922037701	08/03/2013	500.00		2,515.72
58835922037701	08/03/2013	500.00		2,015.72
58835922037701	11/03/2013	1,000.00		1,015.72
58835922037701	12/03/2013		4,200.00	5,215.72
58835922037701	13/03/2013	1,000.00		4,215.72
58835922037701	14/03/2013	1,090.00		3,125.72
58835922037701	15/03/2013	500.00		2,625.72
58835922037701	16/03/2013	500.00		2,125.72
58835922037701	20/03/2013	1,000.00		1,125.72
58835922037701	25/03/2013	1,000.00		125.72
58835922077401	07/03/2013		391.77	70,546.62
58835922077401	07/03/2013	39.18		70,507.44
58835922077401	28/03/2013		5,000.00	75,507.44
58835922127001	07/03/2013		93.75	6,027.08
58835922127001	07/03/2013	9.38		6,017.70
58835922127001	14/03/2013	4,000.00		2,017.70
58835922127001	14/03/2013	17.40		2,000.30
58835922127001	16/03/2013	1,000.00		1,000.30
58835922127001	16/03/2013	17.40		982.90
58835922127001	16/03/2013	500.00		482.90
58835922127001	16/03/2013	17.40		465.50
58835922141901	07/03/2013		10,617.30	1,815,103.54
58835922141901	07/03/2013	1,061.73		1,814,041.81
58835922141901	27/03/2013	180,000.00		1,634,041.81
58835922166001	02/03/2013		4,500.00	5,010.39
58835922166001	06/03/2013		5,000.00	10,010.39
58835922166001	15/03/2013	5,000.00		5,010.39
58835922166001	25/03/2013	1,500.00		3,510.39
58835922183201	07/03/2013		156.87	74,248.56
58835922183201	07/03/2013	15.69		74,232.87
58835922183201	14/03/2013		65,002.00	139,234.87
58835922183201	16/03/2013		27,000.00	166,234.87
58835922196201	07/03/2013		381.48	70,395.12
58835922196201	07/03/2013	38.15		70,356.97
58835922196201	08/03/2013	25,000.00		45,356.97
58835922196201	11/03/2013		50,000.00	95,356.97
58835922196201	14/03/2013		10,000.00	105,356.97
58835922196201	14/03/2013		31,170.00	136,526.97
58835922196201	19/03/2013	5,000.00		131,526.97
58835922196201	21/03/2013	85,000.00		46,526.97
58835922196201	28/03/2013	2,000.00		44,526.97
58835922215701	07/03/2013		58.87	10,064.07
58835922215701	07/03/2013	5.89		10,058.18
58835922221001	04/03/2013		400,000.00	708,005.20
58835922221001	07/03/2013		1,311.29	709,316.49
58835922221001	07/03/2013	131.13		709,185.36
58835922221001	26/03/2013		100,000.00	809,185.36
58835922232601	07/03/2013		13,458.57	1,154,482.00
58835922232601	07/03/2013	1,345.86		1,153,136.14
58835922232601	16/03/2013	300.00		1,152,836.14
58835922232601	22/03/2013	30,000.00		1,122,836.14
58835922232601	25/03/2013	20,000.00		1,102,836.14
58835922235101	02/03/2013	61,500.00		41,011.69
58835922235101	02/03/2013	29.00		40,982.69
58835922235101	04/03/2013		20,000.00	60,982.69
58835922235101	05/03/2013	25,000.00		35,982.69
58835922235101	05/03/2013		10,000.00	45,982.69
58835922235101	07/03/2013		525.41	46,508.10
58835922235101	07/03/2013	52.54		46,455.56
58835922235101	21/03/2013		4,000.00	50,455.56
58835922235101	26/03/2013		5,000.00	55,455.56
58835922247101	07/03/2013		342.55	60,346.45
58835922247101	07/03/2013	34.26		60,312.19
58835922247101	11/03/2013		10,000.00	70,312.19
58835922247101	11/03/2013		10,000.00	80,312.19
58835922247101	18/03/2013		1,400.00	81,712.19
58835922247101	19/03/2013		8,600.00	90,312.19
58835922273901	04/03/2013		1,700,000.00	2,010,002.60
58835922273901	07/03/2013		1,634.88	2,011,637.48
58835922273901	07/03/2013	163.49		2,011,473.99
58835922304701	06/03/2013	30,000.00		355,740.00
58835922304701	07/03/2013		2,220.12	357,960.12
58835922304701	07/03/2013	222.01		357,738.11
58835922304701	11/03/2013	20,000.00		337,738.11
58835922304701	14/03/2013	21,031.00		316,707.11
58835922325001	07/03/2013		64.87	11,244.87
58835922325001	07/03/2013	6.49		11,238.38
58835922325001	11/03/2013		163,165.00	174,403.38
58835922325001	20/03/2013		15,000.00	189,403.38
58835922335301	07/03/2013		5,049.59	1,715,049.59
58835922335301	07/03/2013	504.96		1,714,544.63
58835922335301	08/03/2013	1,700,000.00		14,544.63
58835922335301	09/03/2013	5,000.00		9,544.63
58835922338701	15/03/2013	553.00		8,257.00
58835922338701	15/03/2013	1,033.00		7,224.00
58835922338701	18/03/2013	460.00		6,764.00
58835922338701	20/03/2013	1,033.00		5,731.00
58835922338701	25/03/2013	1,033.33		4,697.67
58835922348501	01/03/2013	5,000.00		5,000.00
58835922365501	07/03/2013		64.04	94,794.04
58835922365501	07/03/2013	6.40		94,787.64
58835922365501	28/03/2013	20,000.00		74,787.64
58835922365501	28/03/2013	20,000.00		54,787.64
58835922365501	28/03/2013	10,000.00		44,787.64
58835922396001	06/03/2013		20,000.00	100,000.00
58835922396001	07/03/2013		235.35	100,235.35
58835922396001	07/03/2013	23.54		100,211.81
58835922396001	14/03/2013		20,000.00	120,211.81
58835922422601	18/03/2013	3,000.00		6,000.00
58835922445101	14/03/2013	5,000.00		5,000.00
58835922445101	21/03/2013		15,000.00	20,000.00
58835922445101	22/03/2013		5,000.00	25,000.00
58835922445101	25/03/2013	1,000.00		24,000.00
58835922445101	25/03/2013	500.00		23,500.00
58835922445101	25/03/2013	5,000.00		18,500.00
58835922445101	29/03/2013	5,500.00		13,000.00
58835922456601	07/03/2013		1,229.71	402,026.71
58835922456601	07/03/2013	122.97		401,903.74
58835922456601	12/03/2013	116.00		401,787.74
58835922456601	12/03/2013	116.00		401,671.74
58835922473001	22/03/2013		122,175.00	123,175.00
58835922548701	07/03/2013		500,000.00	501,000.00
58835922558001	22/03/2013		116,700.00	140,500.00
58835922582901	08/03/2013		100,000.00	110,000.00
58835922582901	19/03/2013		40,000.00	150,000.00
58835922582901	28/03/2013		20,000.00	170,000.00
58835922582901	29/03/2013		375.00	170,375.00
58835922598401	14/03/2013		200,000.00	210,000.00
58835922623001	02/03/2013		604,006.00	605,006.00
58835922623001	12/03/2013	2,500.00		602,506.00
58835922623001	12/03/2013	3,480.00		599,026.00
58835922623001	22/03/2013		3,000.00	602,026.00
58835922660501	13/03/2013		400,000.00	410,000.00
58835922660501	13/03/2013	2,500.00		407,500.00
58835922660501	13/03/2013	2,320.00		405,180.00
58835922725401	06/03/2013		3,000.00	3,000.00
58835922725401	15/03/2013		40,000.00	43,000.00
58835922741301	07/03/2013		23,000.00	23,000.00
58835922741301	25/03/2013		200,000.00	223,000.00
58835922785001	11/03/2013		5,000.00	5,000.00
58835922785001	11/03/2013		99,100.00	104,100.00
58835922790901	11/03/2013		5,000.00	5,000.00
58835922790901	11/03/2013		99,100.00	104,100.00
58835922805801	12/03/2013		21,100.00	21,100.00
58835922805801	14/03/2013		8,400.00	29,500.00
58835922805801	30/03/2013		20,000.00	49,500.00
58835922813801	12/03/2013		10,000.00	10,000.00
58835922813801	19/03/2013		75,000.00	85,000.00
58835922829101	13/03/2013		5,000.00	5,000.00
58835922829101	21/03/2013		41,000.00	46,000.00
58835922837501	14/03/2013		75,000.00	75,000.00
58835922837501	26/03/2013		180,500.00	255,500.00
58835922837501	27/03/2013		125,000.00	380,500.00
58835922837501	28/03/2013	270,000.00		110,500.00
58835922837501	28/03/2013	65,000.00		45,500.00
58835922864001	15/03/2013		95,000.00	95,000.00
58835922866001	15/03/2013		10,000.00	10,000.00
58835922866001	29/03/2013		60,000.00	70,000.00
58835922925401	20/03/2013		30,000.00	30,000.00
58835922925401	21/03/2013		200,000.00	230,000.00
58835922925401	21/03/2013	200,000.00		30,000.00
58835922947701	21/03/2013		500.00	500.00
58835922949701	21/03/2013		10,000.00	10,000.00
58835922949701	27/03/2013		297,000.00	307,000.00
58835923034901	27/03/2013		50,000.00	50,000.00
58835923050301	28/03/2013		50,000.00	50,000.00
58835923053001	28/03/2013		30,000.00	30,000.00
58835923056501	28/03/2013		100.00	100.00
58835923056501	29/03/2013		20,000,000.00	20,000,100.00

<tbody>
</tbody>

 

[khawarameer]

I managed this formula and got the desired results, however this formula is too long any shorter version might help.

=IF(LEFT(H2,3)="588",IFERROR(INDEX($F$2:$F$507,MATCH(1,--(IF($A$2:$A$507=$H2,IF($B$2:$B$507=I$1,1))),0)+(SUMPRODUCT(--(IF($A$2:$A$507=$H2,IF($B$2:$B$507=I$1,1))))-1)),""),IF(IFERROR(INDEX($F$2:$F$507,MATCH(1,--(IF($A$2:$A$507=$H2,IF($B$2:$B$507=I$1,1))),0)+(SUMPRODUCT(--(IF($A$2:$A$507=$H2,IF($B$2:$B$507=I$1,1))))-1)),"")="",H2,IFERROR(INDEX($F$2:$F$507,MATCH(1,--(IF($A$2:$A$507=$H2,IF($B$2:$B$507=I$1,1))),0)+(SUMPRODUCT(--(IF($A$2:$A$507=$H2,IF($B$2:$B$507=I$1,1))))-1)),"")))

regards

Khawar

 

[Robert Mika]

Your resultat table has multiple values of the same account(first account is repeated 10 times) any reason why?
If you need calculation for one account have you tried using Pivot table?

BTW:Please do not post 507 lines of data- is hard to copy and calculated.

 

[khawarameer]

Multiple value in result table is a mistake, however it should not effect the result, and i am sorry for the huge post actually forgot the alternate way (uploading file to a free server), further i have tried the pivot table but it did not work, actually pivot table will not show a single entry it will either sum up or average the entries so i need a short formula.