Numbers: If string in one column matches string in another column value = a third column value

I am not sure how to set up this conditional. Say I have a table like so: | Animal | Totals | |:---- |:------:| | Cat | 10 | | Dog | 6 | | Cow |4 | and a second table like so: | Type | Type Total | Animal | Animal Total | |:---- |:------:| -----:|-----:| | Black | 5 | Cat | XX | | Retriever | 3 | Dog | XX | | Brown | 2 | Cow | XX | | Calico | 5 | Cat | XX | | Hound | 3 | Dog | XX | | Oreo | 2 | Cow | XX | What I am trying to write a formula for is: If a cell value in Table 2, Col C (Animal) matches a cell value in Table 1, Col A (also Animal) populate the corresponding cell in Table 2, Col D (Animal Total) with the value from Table 1, Col B (Totals). I'm not sure how to structure that formula.