Formula Question
 

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!

Formula Question
 

=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!

Formula Question
 

You can concatenate the person's name and their pet name in both sheets and
then do a VLOOKUP based on the concatenated value. In the sheet with the
values, you'd have to set up a field were both names are already joined, so
assuming your concatenated name is column C and your 3 values are columns,
D:F, it would look something like this:

VLOOKUP(CONCATENATE(name, pet name), Other sheet!C:F, 2, FALSE)
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"AKS" wrote:

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!

Formula Question
 

This is not working. Would anyone mind me emailing them the sheets to show
them?

"Bob Phillips" wrote:

=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!