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.