I am using Excel 2007 and need help identifying a formula to complete a table
with data from another range of cells. I can explain best through the
following example:

I want to fill in the missing data in the Table 1 with data from Table 2.
Dog / Red needs to be updated with 111.
Cat / Blue needs to be updated with 555.
Monkey / Yellow needs to be updated with 888.

Table #1
Dog Cat Monkey
Red
Blue
Green
Yellow


Table #2
Dog Red 111
Dog Yellow 333
Cat Red 444
Cat Blue 555
Monkey Yellow 888
Monkey Blue 999

I have tried using Index, but Index uses Rows and Columns and I need a
formula that uses Columns and Columns.

Any help is greatly appreciated.