Index,Indirect, and Match
 

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

Index,Indirect, and Match
 

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"caldog" wrote:
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

Index,Indirect, and Match
 

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 wrote:

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

--

Dave Peterson

Index,Indirect, and Match
 

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

"Dave Peterson" wrote:

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 wrote:

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

--

Dave Peterson