Forum Discussion

Anonymous's avatar
Anonymous
Sep 09, 2020

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 ...
Excel for web
Bennadeau's avatar
Bennadeau
Iron Contributor
Sep 09, 2020

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)

 

      • Anonymous's avatar
        Anonymous
        Sep 11, 2020

        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

Resources