Formula to hyperlink to match

[rslc]

Hi
I have a formula to take me to the result of a match in a list on
another sheet where it selects the matched cell, is there a way to get it to
select the whole row instead of just the cell. This is the formula which
looks for a match for contents of c17
=HYPERLINK("#'validationlists'!a" & MATCH(C17,validationlists!A1:A500,0),
C17)

any help much appreciated
rslc

 

[Gary''s Student]

Make sure the MATCH part is giving you a correct range referernce.

You should be able to hyperlink to a block of cells:

=HYPERLINK("#'some other sheet'!A1:A10")

 

[dbKemp]

Hi
I have a formula to take me to the result of a match in a list on
another sheet where it selects the matched cell, is there a way to get it to
select the whole row instead of just the cell. This is the formula which
looks for a match for contents of c17
=HYPERLINK("#'validationlists'!a" & MATCH(C17,validationlists!A1:A500,0),
C17)

any help much appreciated
rslc

Try leaving the 'a' out and adding a ': after the match and then
repeat the match statement so you get say.... 22:22 vs a22

 

[Dave Peterson]

Check your other post.

Hi
I have a formula to take me to the result of a match in a list on
another sheet where it selects the matched cell, is there a way to get it to
select the whole row instead of just the cell. This is the formula which
looks for a match for contents of c17
=HYPERLINK("#'validationlists'!a" & MATCH(C17,validationlists!A1:A500,0),
C17)

any help much appreciated
rslc