CREATE  MIS REPORT FOR FOLLOWING DATA

1. CREATE MONTHLY SALES DATA SHEET AS SHOWN IN IMAGE
2. SHOW SUM OF MONTHLY SALES AT THE END OF EACH SHEET
3. CREATE 6 SHEETS (JAN-JUNE)
4. MAKE DASH BOARD AS SHOWN IN IMAGE

Create Marksheet using Vlookup 

RESULT SHEET
ENO	NAME	STD	DIV	SUB1	SUB2	SUB3	SUB4	SUB5	SUB6	TOTAL	AVG	RESULT
1001	AAAA	XI	A	55	57	58	59	58	56	343	57	PASS
1002	BBB	XI	B	59	78	88	85	87	78	475	79	PASS
1003	CCC	XII	A	55	57	58	59	58	56	343	57	PASS
1004	POONAM	XI	G	59	78	85	85	87	89	483	81	PASS
1005	RUPALI	XII	A	12	57	58	59	58	45	289	48	FAIL
1006	FF	XI	Y	59	78	88	85	87	63	460	77	PASS
1007	GGG	XI	A	55	57	58	59	58	32	319	53	FAIL
1008	TTTT	XII	O	59	78	85	85	87	45	439	73	PASS
1009	YYY	XI	A	55	57	58	59	89	56	374	62	PASS
1010	UUUU	XII	R	59	78	88	85	56	78	444	74	PASS
GURU NANAK HIGH SCHOOL : enter only eno and get all details of student
E NO	1005
NAME	RUPALI
STD	XII
DIV	59
SUB1	SUB2	SUB3	SUB4	SUB5	SUB6	TOTAL	AVG
12	57	58	59	58	45	289	48.16666667
RESULT	FAIL

v look up

v lookup

finde class and grade using following table

AVG	CLASS	GRADE
25	SECOND	F
30	SECOND	D
35	SECOND	D+
40	SECOND	D++
45	SECOND	C
50	SECOND	C+
55	SECOND	C++
60	FIRST	B
65	FIRST	B+
70	FIRST	B++
75	FIRST	A
80	FIRST	A+
90	FIRST	A++

VLOOKUP
SR	NAME	M1	M2	M3	M4	M5	M6	TOTAL		AVG	GRADE	class	grade
1002	sanju	25	25	25	25	25	25	150		25	F
1003	dada	45	89	99	56	65	98	452		75.33333	A
1004	asmita	89	58	58	89	98	98	490		81.66667	A+
1005	kajal	59	95	59	78	35	65	391		65.16667	B+
1006	sanju	59	78	56	48	89	98	428		71.33333	B++
1007	mangesh	58	48	98	49	52	68	373		62.16667	B
1008	lina	58	49	58	45	89	68	367		61.16667	B
1009	dada	58	78	27	78	68	56	365		60.83333	B
1010	sanju	65	96	59	89	45	58	412		68.66667	B+

INDEX AND MATCH 

CHANGE PRODUCT AND MONTH FIND PRICE OF PRODUCT

PRODUCT	PRODUCT 19
MONTH	DEC
PRICE	242618.4149

NAME	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC
PRODUCT 1	4500	7800	11100	14400	17700	21000	24300	27600	30900	34200	37500	40800
PRODUCT 2	4502	8900	13298	17696	22094	26492	30890	35288	39686	44084	48482	52880
PRODUCT 3	3800	10000	16200	22400	28600	34800	41000	47200	53400	59600	65800	72000
PRODUCT 4	3098	11100	19102	27104	35106	43108	51110	59112	67114	75116	83118	91120
PRODUCT 5	2396	12200	22004	31808	41612	51416	61220	71024	80828	90632	100436	110240
PRODUCT 6	1694	13300	24906	36512	48118	59724	71330	82936	94542	106148	117754	129360
PRODUCT 7	2500	14400	26300	38200	50100	62000	73900	85800	97700	109600	121500	133400
PRODUCT 8	3306	15500	27694	39888	52082	64276	76470	88664	100858	113052	125246	137440
PRODUCT 9	4112	16600	29088	41576	54064	66552	79040	91528	104016	116504	128992	141480
PRODUCT 10	4918	17700	30482	43264	56046	68828	81610	94392	107174	119956	132738	145520
PRODUCT 11	5724	18800	31876	44952	58028	71104	84180	97256	110332	123408	136484	149560
PRODUCT 12	6530	19900	33270	46640	60010	73380	86750	100120	113490	126860	140230	153600
PRODUCT 13	5054.242	21000	36945.76	52891.52	68837.27	84783.03	100728.8	116674.5	132620.3	148566.1	164511.8	180457.6
PRODUCT 14	5228.228	22100	38971.77	55843.54	72715.31	89587.09	106458.9	123330.6	140202.4	157074.2	173945.9	190817.7
PRODUCT 15	5402.214	23200	40997.79	58795.57	76593.36	94391.14	112188.9	129986.7	147784.5	165582.3	183380.1	201177.9
PRODUCT 16	5576.2	24300	43023.8	61747.6	80471.4	99195.2	117919	136642.8	155366.6	174090.4	192814.2	211538
PRODUCT 17	5750.186	25400	45049.81	64699.63	84349.44	103999.3	123649.1	143298.9	162948.7	182598.5	202248.3	221898.1
PRODUCT 18	5924.172	26500	47075.83	67651.66	88227.48	108803.3	129379.1	149955	170530.8	191106.6	211682.4	232258.3
PRODUCT 19	6098.159	27600	49101.84	70603.68	92105.52	113607.4	135109.2	156611	178112.9	199614.7	221116.6	242618.4
PRODUCT 20	6272.145	28700	51127.86	73555.71	95983.57	118411.4	140839.3	163267.1	185695	208122.8	230550.7	252978.6
PRODUCT 21	6446.131	29800	53153.87	76507.74	99861.61	123215.5	146569.3	169923.2	193277.1	216631	239984.8	263338.7
PRODUCT 22	6620.117	30900	55179.88	79459.77	103739.7	128019.5	152299.4	176579.3	200859.2	225139.1	249419	273698.8
PRODUCT 23	6794.103	32000	57205.9	82411.79	107617.7	132823.6	158029.5	183235.4	208441.3	233647.2	258853.1	284059
PRODUCT 24	6968.089	33100	59231.91	85363.82	111495.7	137627.6	163759.6	189891.5	216023.4	242155.3	268287.2	294419.1
PRODUCT 25	7142.075	34200	61257.93	88315.85	115373.8	142431.7	169489.6	196547.6	223605.5	250663.4	277721.3	304779.3
PRODUCT 26	7316.061	35300	63283.94	91267.88	119251.8	147235.8	175219.7	203203.6	231187.6	259171.5	287155.5	315139.4
PRODUCT 27	7490.047	36400	65309.95	94219.91	123129.9	152039.8	180949.8	209859.7	238769.7	267679.6	296589.6	325499.5
PRODUCT 28	7664.033	37500	67335.97	97171.93	127007.9	156843.9	186679.8	216515.8	246351.8	276187.7	306023.7	335859.7
PRODUCT 29	7838.019	38600	69361.98	100124	130885.9	161647.9	192409.9	223171.9	253933.9	284695.9	315457.8	346219.8
PRODUCT 30	8012.005	39700	71388	103076	134764	166452	198140	229828	261516	293204	324892	356580
PRODUCT 31	8185.991	40800	73414.01	106028	138642	171256	203870	236484.1	269098.1	301712.1	334326.1	366940.1
PRODUCT 32	8359.977	41900	75440.02	108980	142520.1	176060.1	209600.1	243140.1	276680.2	310220.2	343760.2	377300.2
PRODUCT 33	8533.963	43000	77466.04	111932.1	146398.1	180864.1	215330.2	249796.2	284262.3	318728.3	353194.3	387660.4
PRODUCT 34	8707.949	44100	79492.05	114884.1	150276.2	185668.2	221060.3	256452.3	291844.4	327236.4	362628.5	398020.5
PRODUCT 35	8881.935	45200	81518.07	117836.1	154154.2	190472.3	226790.3	263108.4	299426.5	335744.5	372062.6	408380.7
PRODUCT 36	9055.921	46300	83544.08	120788.2	158032.2	195276.3	232520.4	269764.5	307008.6	344252.6	381496.7	418740.8
PRODUCT 37	9229.907	47400	85570.09	123740.2	161910.3	200080.4	238250.5	276420.6	314590.7	352760.7	390930.8	429100.9
PRODUCT 38	9403.893	48500	87596.11	126692.2	165788.3	204884.4	243980.5	283076.6	322172.8	361268.9	400365	439461.1
PRODUCT 39	9577.879	49600	89622.12	129644.2	169666.4	209688.5	249710.6	289732.7	329754.8	369777	409799.1	449821.2
PRODUCT 40	9751.865	50700	91648.14	132596.3	173544.4	214492.5	255440.7	296388.8	337336.9	378285.1	419233.2	460181.4
PRODUCT 41	9925.851	51800	93674.15	135548.3	177422.4	219296.6	261170.7	303044.9	344919	386793.2	428667.3	470541.5
PRODUCT 42	10099.84	52900	95700.16	138500.3	181300.5	224100.7	266900.8	309701	352501.1	395301.3	438101.5	480901.6
PRODUCT 43	10273.82	54000	97726.18	141452.4	185178.5	228904.7	272630.9	316357.1	360083.2	403809.4	447535.6	491261.8
PRODUCT 44	10447.81	55100	99752.19	144404.4	189056.6	233708.8	278361	323013.1	367665.3	412317.5	456969.7	501621.9
PRODUCT 45	10621.79	56200	101778.2	147356.4	192934.6	238512.8	284091	329669.2	375247.4	420825.6	466403.8	511982.1
PRODUCT 46	10795.78	57300	103804.2	150308.4	196812.7	243316.9	289821.1	336325.3	382829.5	429333.8	475838	522342.2
PRODUCT 47	10969.77	58400	105830.2	153260.5	200690.7	248120.9	295551.2	342981.4	390411.6	437841.9	485272.1	532702.3
PRODUCT 48	11143.75	59500	107856.2	156212.5	204568.7	252925	301281.2	349637.5	397993.7	446350	494706.2	543062.5
PRODUCT 49	11317.74	60600	109882.3	159164.5	208446.8	257729	307011.3	356293.6	405575.8	454858.1	504140.3	553422.6
PRODUCT 50	11491.72	61700	111908.3	162116.6	212324.8	262533.1	312741.4	362949.7	413157.9	463366.2	513574.5	563782.8