MATCH - HYPERLINK functions...COPY DOWN

  • Thread starter F. Lawrence Kulchar
  • Start date

F

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
 
Ad

Advertisements

F

FLKulchar

ATTN: DAVE PETERSON:

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

Regards,
FLKulchar
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top