Forum Discussion
Vlookup function for looking for web links
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)
- BennadeauSep 11, 2020Iron Contributor
Deleted
Let me know if that's what you were looking for...
- DeletedSep 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
- BennadeauSep 11, 2020Iron Contributor
Deleted
Try this then.