I have, in cell C5, the following:

=MATCH(B5&"*",A1:A1286,0)

The problem is, say in cell B5, is the word: 'SYDNEY'.

I have, perhaps, 4 different 'Sydneys' (scattered throughout A1:A1286)...my
result gives ONLY, the first cell reference scrolling down!

How can I "bring up" the other "Sydney"'s??

Thanks,

FLKulchar