Hi everyone I hope you can help,

I have one row of information for each person in my excel
sheet. I am going to be pulling some data from a DB and
it is formatted as follows..

One Person can only have one row on the sheet. I need to
find out what percentage someone has got of A & B (They
always together make up to 100% when together) Trouble is
there are different parts making up A and B. I can
uniquely identify them through an identifier created a
sheet called Values laid out in the following format.
I know I can use a VLOOKUP function to look in the Values
sheet.

Identifier Category
591 A
555 A
777 A
888 B
999 B

The information I will be pulling is going to be in the
following format.

Person 1 =
ID - 555 Amount - 50
ID - 777 Amount - 50
ID - 999 Amount - 100

Person 2 =
ID - 591 Amount - 100
ID - 888 Amount - 300

Person 1 has 50% Type A and 50% Type B.
Person 2 has 25% Type A and 75% Type B.

Any Ideas?

Richard