Hi,

Try the formula below. It assumes your full table is in A1 - H13 and the 2
lookup values (Month) in J1 and (Year) K1

=INDEX(A1:H13,MATCH(J1,A1:A13,0),MATCH(K1,A1:H1,0) )

Mike

"Adrienne" wrote:

I have a table with years across the top and months in the first column.
Within the table is data for each month of each year. Is there a way I can
point to a cell on another sheet with a particular year and another cell with
a particular month and return the number at the intersection of the
month/year matrix on the first sheet?

Thanks for any help.
--
Adrienne