Two Worksheets with Multiple Rates

[Papi]

Hello All,

I have two worksheets in Excel 2010. The first worksheet has many rows that track equipment at various rates (rates are in column G of the Main worksheet). In the second worksheet it needs to find all the rows that match a size i.e. 8 x 14 may be extracted from several rows matching the first worksheet and size.

The issue is the rate for each row of 8 x 14 and 8 x 16 etc may vary ie. 8 x 14 may have six rows at $3.00 and four rows of the same size at $3.50. Column B below, is a forced rate and should not be there but rather that each month is calculated based on the rates in Column G of the first worksheet.

Edate 2 Modified ADM.xls
	A	B	C	D	E	F
2	Size	Rate	Dec10	Jan11	Feb11	Mar11
3	8x14	3	147	393	1263	1620
4	8x16	3	93	90	93	90
5	8x20	3		81	93	90
Totals

 

[texasalynn]

so are you wanting multiple rows of all the 8x14? Or only the first one that matches? If so then a vlookup will work. If not then I don't understand

 

[Papi]

Hello Texasalynn,

Yes, there would be multiple rows involved as noted below ie. the 8 x 14 are 3.00, 3.50, 3.42 etc. I am not sure how to deal with that to get the actual rate times all the numbers so that in the end they match the total properly.

Edate 2 Modified ADM.xls
	B	C	D	E	F	G	H	I	J
1	Qty	Size	Type	Rate	Prov	DamageType	DamageCost	Aug10	Sep10
2	487	8x14	D	3.00	AB			10	30
3	106	8x14	D	3.50	AB			7	30
4	222	8x20	D	3.00	AB				27
5	146	8x14	D	3.42	AB			1	30
6	165	8x16	D	3.00	AB			31	30
7	129	8x14	D	3.00	AB			31	30
Main