Results 1 to 6 of 6

Thread: Vlookup to search within url
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Mar 2012
    Posts
    98
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Vlookup to search within url

    Hi,

    Is there a way we can search for the names from the below given Data (urls):

    Data (urls)
    Code:
    https://www.box.com/d872/o7j2qy53fh6sikp/myFirst_Report_Abaxis.pdf?dl=0
    https://www.box.com/d872/1ftve998sj5rckn/myFirst_Report_ABC_Group.pdf?dl=0
    https://www.box.com/d872/qe5qbwetpw0qral/myFirst_Report_Abrisa_Technologies.pdf?dl=0
    https://www.box.com/d872/fzbfqzehh1oxuf0/myFirst_Report_Aesculapian.pdf?dl=0
    https://www.box.com/d872/w12nxtswbagswwb/myFirst_Report_Airlite_Plastics.pdf?dl=0
    https://www.box.com/d872/jz08ctfrht6p422/myFirst_Report_AltaLink.pdf?dl=0
    https://www.box.com/d872/44kokwdbq8qdwfv/myFirst_Report_Barnes_Healthcare.pdf?dl=0
    https://www.box.com/d872/l4s37h7fqef8zzj/myFirst_Report_Bausch_Health.pdf?dl=0
    https://www.box.com/d872/x7ce27mwx8src1k/myFirst_Report_Beal_Service.pdf?dl=0
    https://www.box.com/d872/2g1ndew9s367mk5/myFirst_Report_Bella_Vista.pdf?dl=0
    https://www.box.com/d872/cs4q90ekqvnwlcy/myFirst_Report_BioBridge_Global.pdf?dl=0
    https://www.box.com/d872/54h88yytcesr32w/myFirst_Report_Bloodworks_Northwest.pdf?dl=0
    The names to be searched are in Column D, like:

    Column D (Names have spaces not underscores)
    Code:
    Barnes_Healthcare
    Airlite_Plastics
    Bausch_Health
    Bloodworks_Northwest
    Abaxis
    Abrisa_Technologies
    etc

    Any help would be much appreciated.
    Thanks
    Last edited by MASOODAHMAD; Aug 14th, 2019 at 01:19 PM.

  2. #2
    Board Regular kweaver's Avatar
    Join Date
    May 2018
    Location
    La Jolla, CA
    Posts
    629
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Vlookup to search within url

    With your data in column A and the names in D, you could put this in another column (and fill down) to find the row where the name is found in the web address:

    Code:
    =MATCH("*"&D1&"*",$A$1:$A$12,0)
    Last edited by kweaver; Aug 14th, 2019 at 02:13 PM.

  3. #3
    Board Regular
    Join Date
    Mar 2012
    Posts
    98
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Vlookup to search within url

    Thanks kweaver. I'll try this by creating a helper column by replacing spaces with underscores in the Names.

    Can you suggest something as there's a small catch in the names i.e. they don't have underscores as in the URLs, like:

    Barnes Healthcare
    Airlite Plastics
    Bausch Health
    Bloodworks Northwest
    Abaxis
    Abaxis Limited
    Abrisa Technologies

    Also note names might have multiple words.
    Secondly, first or last names might be common at some places.

    Thanks again.

  4. #4
    Board Regular kweaver's Avatar
    Join Date
    May 2018
    Location
    La Jolla, CA
    Posts
    629
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Vlookup to search within url

    What about:
    Code:
    =MATCH("*"&SUBSTITUTE(D1," ","_")&"*",$A$1:$A$12,0)
    Unsure what you mean by the last 2 comments in your last post.

  5. #5
    Board Regular
    Join Date
    Mar 2012
    Posts
    98
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Vlookup to search within url

    Thanks, I'll check this. I'm sure this will work well.

    Have a great day

  6. #6
    Board Regular
    Join Date
    Mar 2012
    Posts
    98
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Vlookup to search within url

    Last edited by MASOODAHMAD; Aug 23rd, 2019 at 01:00 PM.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •