Vlookup function for looking for web links

%3CLINGO-SUB%20id%3D%22lingo-sub-1646824%22%20slang%3D%22en-US%22%3EVlookup%20function%20for%20looking%20for%20web%20links%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1646824%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20know%20how%20do%20run%20a%20vlookup%20in%20Excel%20with%20the%20objective%20of%20finding%20a%20particular%20web%20link%20within%20an%20Excel%20sheet%3F%20(instead%20of%20looking%20for%20a%20product%20name%2C%20looking%20for%20the%20product's%20web%20link%20which%20is%20within%20the%20Excel%20sheet).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20run%20it%2C%20it%20returns%20an%20error.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1646824%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1648979%22%20slang%3D%22en-US%22%3ERe%3A%20Vlookup%20function%20for%20looking%20for%20web%20links%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1648979%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F786526%22%20target%3D%22_blank%22%3E%40CJMMR%3C%2FA%3E%2C%3C%2FP%3E%3CP%3ECan%20you%20share%20an%20example%20of%20your%20spreadsheet%3F%3C%2FP%3E%3CP%3EI'm%20assuming%20you%20are%20already%20aware%20of%20how%20vlookup%20works%3A%3C%2FP%3E%3CP%3E%3CSPAN%3E%3DVLOOKUP(What%20you%20want%20to%20look%20up%2C%20where%20you%20want%20to%20look%20for%20it%2C%20the%20column%20number%20in%20the%20range%20containing%20the%20value%20to%20return%2C%20return%20an%20Approximate%20or%20Exact%20match%20%E2%80%93%20indicated%20as%201%2FTRUE%2C%20or%200%2FFALSE).%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3BSo%20if%20your%20table%20is%20between%20column%20A%20and%20B%20(where%20column%20A%20is%20your%20product%20list%20and%20column%20B%20is%20you%20weblink%20list)%20and%20the%20lookup%20value%20is%20in%20cell%20C2%2C%20the%20formula%20would%20look%20like%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DVLOOKUP(C2%2CA%3AB%2C2%2C0)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1655617%22%20slang%3D%22en-US%22%3ERe%3A%20Vlookup%20function%20for%20looking%20for%20web%20links%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1655617%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F703724%22%20target%3D%22_blank%22%3E%40Bennadeau%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1657361%22%20slang%3D%22en-US%22%3ERe%3A%20Vlookup%20function%20for%20looking%20for%20web%20links%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1657361%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F786526%22%20target%3D%22_blank%22%3E%40CJMMR%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELet%20me%20know%20if%20that's%20what%20you%20were%20looking%20for...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1657622%22%20slang%3D%22en-US%22%3ERe%3A%20Vlookup%20function%20for%20looking%20for%20web%20links%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1657622%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3BBennadeau%2C%20thanks%20for%20the%20reply.%20What%20I%20am%20after%20is%20look%20for%20B2%20(not%20A2)%20in%20the%20vlookup.%20Want%20to%20look%20for%20that%20web%20link%20in%20the%20adjoining%20sheet%20and%20list%20down%20the%20list%20price.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E
Deleted
Not applicable

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

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)

 

@Deleted 

Let me know if that's what you were looking for...

 

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

@Deleted 

Try this then.

Hi Bennadeau

 

Thanks a lot for that. It works now.

 

Appreciate it.

 

Chami

@Deleted 

 

Look up values in a list of data

https://support.microsoft.com/en-us/office/look-up-values-in-a-list-of-data-c249efc5-5847-4329-bfee-ecffead5ef88?ui=en-us&rs=en-us&ad=us

LOOKUP function

https://support.microsoft.com/en-gb/office/lookup-function-446d94af-663b-451d-8251-369d5e3864cb?ui=en-us&rs=en-gb&ad=gb

 

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.