VLOOKUP removing HYPERLINK

[mistahmistah]

Hi y'all,

I'm trying to put together an error response calculator with hyperlinks and having a little trouble

The links live in column b beginning at row 5 and below along with error codes in column a. For example,
[TABLE="width: 500"]
<tbody>[TR]
[TD]23456789[/TD]
[TD]Shortage of Data[/TD]
[/TR]
</tbody>[/TABLE]

B2 is where I would like the formula to be clickable using a vlookup, unless there's another recommendation, when the needed error code is entered into B1. For testing sake please use facebook.com

Thank you!

 

[Danerida]

If you can add a helper column with the link in it (i.e. www.facebook.com) to your data from C5 down, you can use this:

=HYPERLINK("http://" & IFERROR(INDEX($A$5:$C$13,MATCH(B1,$A$5:$A$13,0),3),""),IFERROR(INDEX($A$5:$C$13,MATCH(B1,$A$5:$A$13,0),2),""))

Where:
A5:A13 = your range of codes to match
B5:B13 = your range of descriptions
C5:C13 = your range of links (the helper column)

Hope this helps,
Dan

 

[mistahmistah]

You're the man Dan! Thank you!

 

[Danerida]

Glad to help