Index,Indirect, and Match

[caldog]

Is there a good source to really learn how to use this commands in formulas.
I see and have also been helped by you folks with using these commands, but I
can not seem to get a grasp on the right way to use them when I am trying to
put a formula together.

Great job folks in explaning things in this discussion group.

Steve Martin

 

[Max]

One good start is to try Debra's nice coverage on INDEX/MATCH at her:

http://www.contextures.com/xlFunctions03.html
INDEX/MATCH

There's also some sample workbooks available for d/l & study

 

[Dave Peterson]

Debra Dalgleish has notes for =index(match()):
http://www.contextures.com/xlFunctions03.html

I'm not sure I've ever seen any instructions that describe the use of
=indirect()--well, except for Excel's help!

 

[caldog]

To me using Excel Helps is not much of a help. And thanks for link, have
printed it out and am going to start reading it right now.

Steve