The values coming in are going to be in this format

name-identifier-value

if there was only one identifier and value that would be
easy but with there been many different identifiers which
come into category a or b it is difficult for me to get it
to work.

I havent decided where to put the information yet the only
structures in place are what Ihave posted before

ID

555 - A
666 - A
777 - B
888 - B
999 - B

this is all in a seperate sheet so when the data comes in
as

name-identifier-value
-identifier-value
-identifier-value

if you see what I mean!!!

LOL

-----Original Message-----
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

.