I wish to use the MATCH function to copy down to find subsequent
matches of my look-up value, NOT ONLY the first match.
For example, I am searching for ‘Sydney’ as my look-up value.

In cell B5, I have     "Sydney"

In cell C5, i have     =MATCH($B$5&"*",A1:A1291,0)
         (which finds me my first sydney)

In cell D5, I have     =HYPERLINK("#A"&C5,"GO TO")

AT THIS POINT, I CAN USE THE HYPERLINK TO GO TO THE
1st MATCH OF ‘Sydney’.

Cell C5 returned 683…therefore, my hyperlink took me to cell A683
to locate my 1st ‘Sydney.’

But…HOW CAN I FURTHER SEARCH FOR THE OTHER ‘Sydneys’ which
are farther down the page?????

Thanks,

FLKulchar