MATCH - HYPERLINK functions...COPY DOWN
 

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

MATCH - HYPERLINK functions...COPY DOWN
 

ATTN: DAVE PETERSON:

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

Regards,
FLKulchar
"F. Lawrence Kulchar" wrote in
message ...
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

MATCH - HYPERLINK functions...COPY DOWN
 

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

Look for the section "Arbitrary Lookups"



FLKulchar wrote:

ATTN: DAVE PETERSON:

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

Regards,
FLKulchar
"F. Lawrence Kulchar" wrote in
message ...
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


--

Dave Peterson