Formula requested

[rockybell_77]

Hello
I have a data given below. I want to do the following-
Define formula after Equipment-3 column such that, search which 'Product' use Equipment-1, then find highest 'weightage' among the product uses 'Equipment-1' and then pick the 'Dose' of the highest 'weightage' value product and muliply with 'batch' of the product in that row and divide by 'Dose in that row. Like in below case forrmula shall search that Product A & D uses R-50 and Product D has maximum Weighatge (64), Hence in row of product 'A' in cell next to 'Equipment-3', automatically formula shall multiply 'Dose' of D i.e. 250 with Batch of 'A' i.e. 150 and divide bby Dose of 'A' i.e. 5...This is to bbe done of each column "equipment-1, 2 and 3...so on. Please help

Product	Batch	Dose	weightage	Equipment-1	Equipment-2	Equipment-3
A	150	5	55	R-50
B	60	100	61		R250
c	500	1	54			R500
D	200	250	61	R-50
E	10	250	54			R500

<tbody>
</tbody>

 

[jorismoerings]

Hi,

Wasn't this already solved by the answer you got on: http://www.excelforum.com/excel-form...lculation.html

 

[István Hirsch]

To make your explanation clearer please calculate and show in the table the expected results produced manually.

 

[Smitty]

Welcome to the Board!

Crossposted: http://www.excelforum.com/excel-form...lculation.html

Formula to meet multiple criteria and perform calculation

It's not a big deal, but we ask that you point it out so you don't have a bunch of people in different places all trying to do the same thing.

Please see: Excelguru Help Site - A message to forum cross posters