View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AKS AKS is offline
external usenet poster
 
Posts: 7
Default 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!