View Single Post
  #4   Report Post  
excelhelp_84 excelhelp_84 is offline
Junior Member
 
Posts: 3
Default

Quote:
Originally Posted by Spencer101 View Post
Sounds like "Homework Help" to me...
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))