Forum Discussion
Solved
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...
- 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))
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))
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.
- Xlookup is to be preferred unless this must also work on older versions of Excel
