And if you know that...

Sure do!

perhaps you'll also know how to explain the whole thing to me.

My specialty, but I'll wait to see if TM responds. I would be interested to
read their explanation of both questions.

--
Biff
Microsoft Excel MVP


"Dave" wrote in message
...
Hi,
Looking at an answer from Teethless Mama to someone else's question,
raised
yet another question. (what a surprise)
The formula was: =OR(INDEX(A1:A3=B2,))
I was curious about the use of Index with a blank 2nd argument.
So breaking it down, I entered data into cells A1 thru A9, then in another
cell entered: =INDEX(A1:A9,)
This always returned the data from the 3rd cell (A3)
Can anyone tell me why please?
And if you know that, perhaps you'll also know how to explain the whole
thing to me.
Regards - Dave.