Pls. Help on Formuale

[ssraghunathan]

Dear all,


At the outset, i woould like to thank all the forum members for their contribution to clarify so many excell queries. Really amazing ..!!


With this in my mind, i thought you may help me to provide a solutions to my query.


I have few sales guys who are eligible for incentives as per their grade and % of incentive would be based on their grade/level.


Eg. A grade employee who has rated 5 (excellent), he is eligible for 15% of sales incentive whereas it may be 30% if the employee in B Grade.


I need to capture the % of incentive automatically in the grid / column.


The sample worksheet is attached for ref.


Pls. help.


http://dl.dropbox.com/u/67680061/Sample.xlsx


Thanks


Raghu

 

[Hui]

Raghu

In D2 enter


=INDEX($H$2:$L$6,MATCH(C2,$G$2:$G$6,0),MATCH(B2,$H$1:$L$1,0))

or

=SUMPRODUCT(($H$1:$L$1=B2)*($G$2:$G$6=C2)*($H$2:$L$6))


Copy either formula down

 

[ssraghunathan]

Thanks Hui, Really greatful to you with your quick response.


Regards


Raghunathan S