Okay - now I'm getting somewhere. However, for the sake of simplifying my question, I omitted the fact that there is irrelevant data in columns B through H, and that the number I want to pull back is actually in Row I.

In the 2008 sheet, I am entering this formula in row K, and wanting to get the data from Row I in the 2009 sheet. I figured I could wrangle it, but changing the B to an I in your formula oddly doesn't change anything in the result.