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