Look up - locate - retun cross referenced value

[Amolvijay]

There are three types of resources A, B and C.

A is senior resource to be placed in US
B is middle level reource to be placed in UK
C is Junior to be placed in Germany
Row 8:11 depicts the rate for each senior, middle and junior grade for each geography..
---------------------
Now as per project plan there is specific requirement of resources row 14:17
This table has to be read as, for Week 1, project need is to have 2 A type, 1 C type resource.
--------------
Requirement is table row 20:22 sould return total rev (rate*no of resources) defined in Row 8:11 from each resource in each week....

Hope I am able to put down my problem clearly..

Thanking in anticipation......

[FDibbins]

If I understand you correctly, try this, copied down and across...

=IF(B15="","",B15*INDEX($B9:$D9,1,MATCH($A25,$B2:$D2,0)))