bishop7262
Board Regular
- Joined
- Jan 9, 2010
- Messages
- 87
I have a vlookup that returns a hyperlink. I want it to return any hyperlink and rename it as, "Video". Is there a way to do that? Here is what that hyperlink(vlookup) setup look like:
=HYPERLINK(IFERROR(VLOOKUP(B7,BackCol,2,FALSE),IFERROR(VLOOKUP(B7,BicepsCol,2,FALSE),IFERROR(VLOOKUP(B7,ChestCol,2,FALSE),""))))
Thank you
=HYPERLINK(IFERROR(VLOOKUP(B7,BackCol,2,FALSE),IFERROR(VLOOKUP(B7,BicepsCol,2,FALSE),IFERROR(VLOOKUP(B7,ChestCol,2,FALSE),""))))
Thank you