Quote Originally Posted by Bob Phillips View Post
The problem is Pepe that row contains demerge and the list contains merge and demerge, so your Search has two matches, demerge is at character 47, merge at 49, and doing a lookup of a big number against it matches the 49, so it matches the merge not demerge, hence 2.
But so would your solution fail if a particular row contained e.g. "Takeover (hostile)" and the (sorted) table contained both "Takeover" and "Takeover (hostile)".

True, that is not an issue with the current choice of keywords, but in general the point stands...

Regards