Originally Posted by excelhelp_84

I'm sorry but I'm sure there are lots of ppl that come on here for "homework help" they may be less subtle than me but still... What's the deal? is that against the forum rules?

If I can get pointed in the right direction, that can help me as well. The format of the formula should be something along the lines of:

INDEX(INDIRECT(VLOOKUP("Disc",TablDef,MATCH("Tabl_ Def",TablCol,0),FALSE),TRUE),MATCH($E$15,INDIRECT( VLOOKUP("Disc",TablDef,MATCH("row_num",TablCol,0), FALSE),TRUE),1),MATCH("Discount",INDIRECT(VLOOKUP( "Disc",TablDef,MATCH("col_num",TablCol,0),FALSE),T RUE),0))