Hyperlinked Vlookup

[Henwelder]

Hi There,

I have a spreadsheet which has a front page that looks up a name and returns values against that name from a vast second tab. What I would like to do is once I have selected a name and it shows the values, hyperlink these values so that if the user clicks on the number it takes them to the relevant box in the second tab. So they can change the value if they need to easily.

I'm using the following formula: =HYPERLINK(VLOOKUP(E2,AccountAttractiveness!$A$4:$AJ$254,33,0),VLOOKUP(E2,AccountAttractiveness!$A$4:$AJ$254,33,0))

All I get however is cannot return specific value. Any ideas?

Thanks

 

[Jerry Sullivan]

Here's one way...

=HYPERLINK("#AccountAttractiveness!AJ" & 3+MATCH(E2,AccountAttractiveness!$A$4:$A$254,0),
INDEX(AccountAttractiveness!$AJ$4:$AJ$254,MATCH(E2,AccountAttractiveness!$A$4:$A$254,0)))

You could simplify the formula if you want to use a helper cell to hold the Match formula result.

 

[Henwelder]

Thanks you very much JS411 that is perfect and works wonderfully.

Cheers
Henwelder