Re: Tough Excel Question
 

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.