If you want to build hyperlink in excel, you can do the same by using the HYPERLINK Function and VLOOKUP Function. But the thing is what’s the need of building a hyperlink in sheet🤔?
The purpose to build a hyperlink is simple, when you are dealing with loads of data which is related to (say, social media😜 or online content), you need to mention the link as well. So, hyperlink provides a sophistication as well as fast pace thing because if you want to check out the site all you need to do is click and woooooshhhhh🛬….
So, let’s take an example for the same🤓:
As you can see in the image above, we have taken 4 common websites i.e. Google, Facebook, Instagram, and Twitter, also we have provided the links of the same.
Now to create the hyperlink of the same, here’s what we will do:
Step 1: Input the formula =HYPERLINK(
First, we will input the HYPERLINK Function which is as follows:
Step 2: Input the required values in the formula
The following formula requires link location and a friendly name (which can be optional at times but not in this case).
Step 3: Input the formula =VLOOKUP(
Then in the link location we will input the VLOOKUP Function which is as follows:
Step 4: Input the required values in the formula
The following formula requires a lookup value, table array, column index number, and range lookup.
Now, to begin with the lookup value, we will select the cell A4 i.e. Google.
Next, we will select the table array🤓, please note that in a table array you have to include the column heading as well. So, the table array as per the example above is A3:D7.
Then we will head to the column index number, which will be 2. This is because the link is in the second column number, so 2 it is😎!
Then we will move to the point of range lookup which provides us two options, which are as follows:
(…)TRUE – Approximate match
(…)FALSE – Exact match
We will pick the second option, i.e. (…)FALSE – Exact match. This is because we have provided all the information in the formula which is the exact match i.e. the exact requirement, if it would be on the basis of approximation then we would have gone for the other option.
After selecting the range lookup, we will close the VLOOKUP Formula and move forward to the friendly name in the HYPERLINK Formula. It’s your wish if you want to use another name but generally people use the simple way only, just like it’s shown in the image above.
Please note🤔: If you want to choose the friendly name as per your choice and not the one which is already present in the sheet, then you need to jot down the friendly name in the formula itself that too in the quotation marks (because you are adding a particular specification🤓).
Now all you have to do is press enter, and BAAAAAAMMMMMM🔫!!!! There you go, a hyperlink for Google.
If you move your cursor on it, you can see the details of the website and if you click on it, you will directly move to that website (just like it’s shown in the image above👆).
It’s that simple😊.
Now, all you have to do is drag down the formula till it is required (just like it’s shown in the image above).
So, it’s easy, isn’t it😉?