Hi,

Try

=SUMPRODUCT((A2:A7=G1)*(B2:B7=G2)*(C1:E1=G3)*C2:E7 )

Where your data runs from A1:E7 with titles on row 1 and the Magazine, Year
and AddSize in G1, G2, and G3.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Kokomojo" wrote:

My workbook is set up as follows:

Magazine,Year,FullPage,HalfPage,QuarterPage
People,2009,300,200,100
Time,2009,150,100,50
Us,2009,200,100,0
People,2008,250,225,200
Time,2008,100,50,0
Us,2008,50,25,0

I would like to set up a lookup table to and write a function to tell me,
for example, what the FullPage number is People in 2008.

Thanks!