table look up help!

[mark]

Hello, I would like to look up a value from the below
table, referencing the year and month and returning the
value in the table.

Thank you in advance for your assistance
Mark



Month 2004 2005
1 0 13
2 0 9
3 0 5
4 0 12
5 9 13
6 12 10
7 17 8
8 16 10
9 8 11
10 0 8
11 7 8
12 6 12

 

[Jason Morin]

Try:

=INDEX(tbl,MATCH(J1,A:A,0),MATCH(K1,1:1,0))

where:

tbl = A1:C13
J1 = month
K1 = year

HTH
Jason
Atlanta, GA