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