You can use that book analogy, but think of it in the manner that *YOU* are
creating the index.

In a book, the index contains words or subjects (on the left side), and
where they can be found (page numbers on the right side).

In XL, you create the index where the words or subjects pertain to cells
(the range you specify - on the left side), and the Match() function is the
page number (on the right side).

All you have to remember, is that wherever you *start* your range( Row1,
Row100, or Row 1000), that's page *1*.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Dave" wrote in message
...
This is by way of a small XL grumble.
Every time I want to use Index or Match, I can never remember which is
which, and always have to look it up.
I thought I may be able to apply logic to help me remember. (So naive)
When I use the index in a book, I look up a word (value), in the index
(table), and get given a page number (reference).
Why the heck does XL do the reverse? What good is a book index where you
look up a page number to see what's on it? Am I missing something? Does
anyone else get these two functions mixed up, or am I pathetically alone?
Regards - Dave.