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.