Ragingfred
New Member
- Joined
- May 15, 2018
- Messages
- 7
- Office Version
- 2016
- Platform
- Windows
I'm trying to set up a vlookup that displays a hyperlink from Cell A and displays the text from Cell B
First Attempt: Displays the actual link, verified that it works.
Second Attempt: Displays link as text from F2, works only on first vlookup of course.
Third Attempt: This just threw an error.
First Attempt: Displays the actual link, verified that it works.
=HYPERLINK(VLOOKUP($B$3,Address!$A$2:$J$52,7,FALSE),"")
Second Attempt: Displays link as text from F2, works only on first vlookup of course.
=HYPERLINK(VLOOKUP($B$3,Address!$A$2:$J$52,7,FALSE),Address!F2)
Third Attempt: This just threw an error.
=HYPERLINK(VLOOKUP($B$3,Address!$B$2:$J$52,7,FALSE),VLOOKUP($B$3,Address!$B$2:$J$52,6,FALSE))