I have a somewhat odd need. I have 18 each with 2 sheets (will probably add them into 1 excel file). The sheets are listed by government program and I need to do averages for different programs. The problem is that if NJ doesn't have the program then it gets out. So Education Pensions might be row 45 for NJ but row 47 for NYC. But, each program has a unique identifier. So instead of specifying a sheet, column and row, I want to specify the sheet and column and have a function that repots the row.

Is there a way to do this in Excel 2007?