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