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