Cross Referencing -

Hi Experts..

Request for your help..

I am working on revenue plan..

I have decided three categories for three geos..each one denoted by unique letter..

I have another staffing plan where I have mentioned in which week I will be needing that category.

I wish to get a formula which will look for caterogy in each week (A, B or C) and return a value which will be multiplication of no of heads under each category for each week, tracedown geo and grade for that category, get the value...

PF attached excel for more details...

Sorry, I dont think we understand your wants.

Can you clearly identify what you want as an outcome, and what the inputs are?

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

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