Similar to Jacob's solution, but non-array:

=INDEX(C:C,SUMPRODUCT(--(A2:A10="People"),--(B2:B10=2008),ROW(A2:A10)))

Note that SUMPRODUCT can't callout entire column (e.g. A:A) unless using XL
2007.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


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