Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Senior Member
 
Posts: 663
Default

Quote:
Originally Posted by 'Don Guillett[_2_
And just what is this for
We're supposed to use the index and indirect functions for these
Sounds like "Homework Help" to me...
  #2   Report Post  
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))
  #3   Report Post  
Junior Member
 
Posts: 3
Default

Quote:
Originally Posted by excelhelp_84 View Post
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))
I guess I dont understand how to use the above example in what I have to do. It wasn't explained well to me how and what an indirect vlookup does in an index
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Indirect with an Index Match Function Mike[_16_] Excel Worksheet Functions 3 April 17th 09 04:08 PM
Indirect with index and match Kashyap Excel Worksheet Functions 2 March 18th 09 04:24 AM
Indirect function in Index/Match Array hoosier41 Excel Discussion (Misc queries) 5 June 20th 08 10:09 PM
Match, Index, Indirect ? PCLIVE Excel Worksheet Functions 1 April 6th 07 05:02 PM
Index,Indirect, and Match caldog Excel Worksheet Functions 3 November 10th 06 11:57 PM


All times are GMT +1. The time now is 03:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"