I am using Excel 2007

Try this...

Table 1 column headers B1:D1, row headers A2:A5

Table 2 in the range A10:C15

Enter this formula in B2:

=SUMIFS($C$10:$C$15,$A$10:$A$15,B$1,$B$10:$B$15,$A 2)

Copy across to D2 then down to B5:D5

If you don't want to see any 0 results I'd use a custom number format of
General;General;

--
Biff
Microsoft Excel MVP


"Flintstone" wrote in message
...
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.