Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match Index | Excel Worksheet Functions | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
Find a match that;s not exact | Excel Worksheet Functions | |||
Vlookup, Index & Match | Excel Worksheet Functions |