[dabluebery]

The right answer is to use the index function, it's the "right" way to do it. Make this post over at the Mrexcel.com forums, those people will give you a spreadsheet, documentation, commented notes, and the history of the index function in 10 minutes.