mcmahobt,

Thanks for your quick solution! I cut and paste into my spreadsheet and after updating the sheet names from the generic "Sheet1" etc., I got a calculation error. Since this formula was entered into cell D9 on Sheet1 according to your instruction, I deleted that sheet name since it was already on that sheet - was that the correct thing to do?

However cell D9 is blank, so shouldn't this formula go in cell C14 where this calculation should occur?

My Formula Changes:
=INDEX('Grading-Tables'!B$6:B$18,MATCH($C$9,INDIRECT('Grading-Tables'!&ADDRESS(6,7+IF($B$1="men",MATCH($B$2,'Grading-Tables'!$H$5:$M$5,0),MATCH($B$2,'Grading-Tables'!O5:T5,0)))&":"&ADDRESS(18,7+IF($B$1="men",MATCH($B$2,'Grading-Tables'!$H$5:$M$5,0),MATCH($B$2,'Grading-Tables'!$O$5:$T$5,0)))),0))

Your Original Formula:
=INDEX(Sheet2!B$6:B$18,MATCH($C$9,INDIRECT("Sheet2!"&ADDRESS(6,7+IF(Sheet1!$B$1="men",MATCH(Sheet1!$B$2,Sheet2!$H$5:$M$5,0),MATCH(Sheet1!$B$2,Sheet2!$O$5:$T$5,0)))&":"&ADDRESS(18,7+IF(Sheet1!$B$1="men",MATCH(Sheet1!$B$2,Sheet2!$H$5:$M$5,0),MATCH(Sheet1!$B$2,Sheet2!$O$5:$T$5,0)))),0))

Thanks much,

Patrick