Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]() Quote:
|
#2
![]() |
|||
|
|||
![]()
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)) |
#3
![]() |
|||
|
|||
![]() Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using Indirect with an Index Match Function | Excel Worksheet Functions | |||
Indirect with index and match | Excel Worksheet Functions | |||
Indirect function in Index/Match Array | Excel Discussion (Misc queries) | |||
Match, Index, Indirect ? | Excel Worksheet Functions | |||
Index,Indirect, and Match | Excel Worksheet Functions |