Try this...

With your table in the range A1:E7

Lookup values:

G1 = People
H1 = 2008
I1 = FullPage

=SUMPRODUCT(--(A2:A7=G1),--(B2:B7=H1),INDEX(C2:E7,,MATCH(I1,C1:E1,0)))

--
Biff
Microsoft Excel MVP


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