I have a formula that creates a clickable hyperlink to a list on another
sheet, when clicked you are taken to the matched cell however i would like
the formula to select the whole row as opposed to just the cell. this is my
formula
=HYPERLINK("#'validationlists'!a" & MATCH(C17,validationlists!A1:A500,0),
C17)

any help much appreciated

rslc