MATCH - HYPERLINK functions...COPY DOWN

[F. Lawrence Kulchar]

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

 

[FLKulchar]

ATTN: DAVE PETERSON:

You helped me before on this...if you're out there, please help me again.

Regards,
FLKulchar

 

[Dave Peterson]

Chip Pearson shares a technique to return arbitrary matches:
http://www.cpearson.com/excel/TablesAndLookups.aspx

Look for the section "Arbitrary Lookups"