Formula that can find result and include hyperlinks

[tonii4516]

Hello,

I been trying to figure this one out but I can't find a way to do it without using macros.

In the "warranty" section, I want to be able to match the mode value with the list on column G. The difference is that the list will have hyperlinks to a downloadable format. Some of the values already have hyperlnks.

I used the vlookup but it only returns the text without the hyperlink. Then I tried using the hyperlink and vlookup function together but it will give me the text as a hyperlink but not with the hyperlink provided on the list in column G

I attached the link below.

I really appreciate the help.

https://drive.google.com/open?id=17w5T6lqjqwb8bD0I_1aLVbj9k28pPjQ1

 

[Chrisdontm]

Your link would not open up, but consider this;

For the link to work it must be the actual address of the link.
So in your Table in the first column let it be the item you are looking up.
In the second column let it be the actual link.
In the third column let it be the nickname of the link.

Then in the Hyperlink formula in the link reference use the VLOOKUP to find the actual link in the second column.
In the part of the "Friendly Name" use the third column of the VLOOKUP.

Then the link ought to work.

 

[tonii4516]

I like your suggestion, I am going to try to do that.

Either way, I am going to attach another link for the table.

I appreciate your time.

https://drive.google.com/open?id=1kCXKgr585_rzm0d9c6TauMBoa4sT3bx_

 

[Chrisdontm]

I was trying it out and it seems to bring everything over as a hyperlink...
Unless you name the links with a character that could be identified in the look up,
It would seem that you would need to get into macros...

In case you want to see, the formula I used in cell: D5

=HYPERLINK(VLOOKUP($B5,$G$4:$G$101,1,0),VLOOKUP($B5,$G$4:$G$101,1,0))