=INDEX(Sheet2!C:C,MATCH(1,(Sheet2!A1:$A$200=$A$2)* (Sheet2!$B$1:$B$200=B2),0))

this is an array formula, so commit with Ctrl-Shift-Enter, not just Enter.

--
__________________________________
HTH

Bob

"AKS" wrote in message
...
I have two separate sheets. One sheet contains a person's name with their
pets name and an attached value (3 separate columns). In the other sheet
I
have the same person's name with their pets. In the value column of the
second sheet I want it to look up the exact person's name and pet match
and
give me the attached value. Anyone have any ideas. I have tried several
different things with no luck.

Thanks!