Sep 08 2020 06:35 PM
Sep 08 2020 06:35 PM
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
Sep 09 2020 07:59 AM
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)
Sep 11 2020 06:34 AM
@Deleted
Let me know if that's what you were looking for...
Sep 11 2020 07:40 AM
Hi Bennadeau, thanks for the reply. What I am after is look for B2 (not A2) in the vlookup. Want to look for that web link in the adjoining sheet and list down the list price.
Thanks
Sep 11 2020 09:36 AM
@Deleted
Try this then.
Sep 15 2020 10:39 PM
Hi Bennadeau
Thanks a lot for that. It works now.
Appreciate it.
Chami
Sep 15 2020 11:47 PM
@Deleted
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.