I figured it out. Thank you very much, Miraun, for your help. You got me on the right track. This is the formula that worked: =VLOOKUP(A2,'2009'!A:I,9,FALSE)

I was misunderstanding the use of A:B and the "2" in your example. Makes sense now.