Forum Discussion
edins4250
Nov 05, 2021Copper Contributor
Hyperlink Function w/ Match/Index or Vlookup
Greetings all, Since SharePoint updates links every time a PDF is replaced, I'm looking to use a HYPERLINK function that'll hopefully only need to be updated in one tab (links column C) and via a...
- Nov 05, 2021This formula (in col B of the three sheets next to sheet Links) should get you going:
=HYPERLINK(XLOOKUP(A2,Links!$A$2:$A$9,Links!$C$2:$C$9),XLOOKUP(A2,Links!$A$2:$A$9,Links!$B$2:$B$9))
JKPieterse
Nov 05, 2021Silver Contributor
This formula (in col B of the three sheets next to sheet Links) should get you going:
=HYPERLINK(XLOOKUP(A2,Links!$A$2:$A$9,Links!$C$2:$C$9),XLOOKUP(A2,Links!$A$2:$A$9,Links!$B$2:$B$9))
=HYPERLINK(XLOOKUP(A2,Links!$A$2:$A$9,Links!$C$2:$C$9),XLOOKUP(A2,Links!$A$2:$A$9,Links!$B$2:$B$9))
- edins4250Nov 05, 2021Copper Contributor
JKPieterse thank you so much this works! Another solution I found to work is essentially the same formula as yours but a vlookup instead of xlookup.
- JKPieterseNov 05, 2021Silver ContributorXlookup is to be preferred unless this must also work on older versions of Excel