=SUMPRODUCT(--(Magazine="People"),--(Year=2008),FullPage)


"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!