Harlan,
Thankyou. I now understand. I can't fault the laziness <vbg

--
Regards
Roger Govier
"Harlan Grove" wrote in message
oups.com...
Roger Govier wrote...
...
However, I am still puzzled as to why you are looking up "2".
If I substitute "0" for "2" I get #N/A
If I substitute "1" for "2" I get the string from GY1 to the end
Any value from 2 onward returns the desired result.
Why is it 2?

It could be 1.0000000000001, but I'm lazy and prefer 2 because it's
shorter.

The point I seem to have failed to make is that when the value sought
is *STRICTLY* *LARGER* than (**NOT** equal to or larger than) the
largest value in the range (or array) searched, Excel immediately
returns a reference to the last number entry in the range (array)
searched. If the value sought occurs in the range or array (as 1 does
multiple times in the array 1/(MID(...)=",")), then Excel could return
a reference to *ANY* of those matches, usually the middle such match. I
didn't want a middle match, so I ensured my value sought would be
larger than any number value in the array I searched.