hi-
i need to return a value based on 2 conditions... i have a list of 500+
names, they all have a unique identifier (employee id) so i need to get
different values/scores from tab 2 into tab 1.

so, for john i'd have his score from category 1 (80%) in tab 1 C2 and his
score for category 2 (20%) in D2 and son on.

i did a simple v-lookup
=(VLOOKUP(C$2,Tab 2!$A:$C,3,FALSE))
BUT it gives me the first score it finds that matches the category name and
I need to score for each category for each employee... any ideas???

tab 1:
A B C D E
name - id - category 1 - category 2 - category 3
john 123
tim 456
steven 789

tab 2:
A B C
categories - id - score
category 1 123 80%
category 2 123 20%
category 2 456 30%
category 3 123 5%
category 1 789 30%