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

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")
--
Gary''s Student - gsnu200812


"rslc" wrote:

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

On Nov 7, 3:12 am, "rslc" wrote:
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

Check your other post.

rslc wrote:

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

--

Dave Peterson