Matching two columns and pulling most common data from a third column?

[aware073]

Hey all, I am trying to come up with a formula to pull the data that matches from column A in this sheet..

Excel 2010
	A	B	C	D	E	F
1	Material	Plant	Material Description	Ext. Material Group	Storage Bin	Valuated UnRes Stock
2	200035	M001	SWITCH	M11	E0103BC	1.000
3	200037	M001	LOCKWASHER, M20 EXTERNAL	L19	F0106DB	1.000
4	200040	M001	SEAL, WIRE (U/C# 187277) 0002697-0009	M13	D0803AC	30.000
AEC

To all the same entries in column E in this sheet, and return the most common answer from column H. Basically I need to know which GL account (Sheet 2, H) the material number in sheet 1 column A is issued out as most frequently. Any suggestions??

Excel 2010
	A	B	C	D	E	F	G	H
1	Co Code	Plant	MoveType	Mat. Doc.	Material	Material Desc.	G/L Acct	G/L Acct Name
2	8100	M001	201	4900399047	210683	(R)CONTROLLER	724150	Maint-Supplies
3	8100	M001	201	4900399047	214879	SPRING, LEAF THREE	724150	Maint-Supplies
4	8100	M001	201	4900399181	214663	BEARING,PILLOW BLOCK, 10 IN. SAF056KAX10	723180	Belt-Belt Drives
5	8100	M001	201	4900399545	203407	U-JOINT	724150	Maint-Supplies
MVMTS

 

[aware073]

Hey Eric, Sorry for the delay. This formula keeps freezing the whole spreadsheet everytime I drag it down. Any suggestions? Also it will need to return the first account found if none are used more than once. Thanks so much for your help.

 

[aware073]

Still trying to figure this one out if anyone can help!!