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