But as an scientist then I think of a whole bunch of numbers (an array), I
tell my mate to look at the one with index 5,6, Because that is how I think
of index even through I am an author. And that was the way early programmers
used the term - mathematically.
It is all in the eye of the beholder. Microsoft is not being 'evil' just to
get you upset, honest!
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"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.