I've recently gone from excel 2000 to 2007, so if there are obvious solutions to this that I've missed, let me know (and pardon the stupid question.)

I've got a table of sales data - each cell is a dollar amount, with rows by month (Jan, Feb, Mar, etc.) and columns by year. I've set up a separate table elsewhere on the same worksheet that finds and displays the top 10 values from the aforementioned table. What I'm trying (unsuccessfully, thus far) to do in the second table is to display the month and year for each value in the top 10 list.

I'm using the 'LARGE' function to determine the top 10 values, and that's working fine. However, I've tried various iterations of INDIRECT, VLOOKUP, HLOOKUP, MATCH and CELL to derive the actual cell value of my calculated result - no joy.

Specifically, my list of 10 values are calculated in c43:c52 based on the array elsewhere on the page. I though this would be the solution: =CELL("address",INDIRECT(C43)), but it's not.

Ideas? Thanks.