Assign a category to a cell based on two conditions

I have Worksheet 1 with individual animals (column A), from multiple batches (column B), each with a tag code (column C) that represents a family (column D). I need to fill in the family (column D). On a second worksheet, I have the tag codes that represent each family, by batch.
Individuals in worksheet 1 should be assigned the family by looking up their batch and tag in Worksheet 2.

Attached is an excerpt of the worksheets.

Thanks

Use this:

Formula:

Please Login or Register  to view this content.

Thanks a lot bebo021999 and zbor for the quick responses. Both solutions seem to work. I'll take a closer look to understand how they worked.
You saved me a lot of time and work...