Forum Discussion
Vlookup function for looking for web links
Hi all
Does anyone know how do run a vlookup in Excel with the objective of finding a particular web link within an Excel sheet? (instead of looking for a product name, looking for the product's web link which is within the Excel sheet).
When I run it, it returns an error.
Thanks
7 Replies
Deleted
Look up values in a list of data
LOOKUP function
Example:
What do I have to do so that I can click on the hyperlink in the formula cell and get to the appropriate place?
Formula:
=HYPERLINK("#"&SUBSTITUTE(VLOOKUP($A$4,'linktabelle!'!$B$1:$H$38,4,FALSE),"'",""),"Link to Site")
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Hi Deleted,
Can you share an example of your spreadsheet?
I'm assuming you are already aware of how vlookup works:
=VLOOKUP(What you want to look up, where you want to look for it, the column number in the range containing the value to return, return an Approximate or Exact match – indicated as 1/TRUE, or 0/FALSE).
So if your table is between column A and B (where column A is your product list and column B is you weblink list) and the lookup value is in cell C2, the formula would look like this.
=VLOOKUP(C2,A:B,2,0)
