+ Reply to Thread
Results 1 to 2 of 2

VBA to replace multiple values with VLookup in hyperlink form

  1. #1
    Registered User
    Join Date
    08-24-2020
    Location
    Delhi, India
    MS-Off Ver
    2007
    Posts
    1

    VBA to replace multiple values with VLookup in hyperlink form

    Hi

    I have a sheet which has paragraphs with people's name and my vlookup list of names appearing in the paragraph is in the other sheet. I want to use vlookup to identify the people's names, and convert them into hyperlink to their respective pages on our website.

    Available data for lookup:

    Person's Name Web URL

    Alain Robbe-Grillet artist/alain-robbe-grillet
    F. N. Souza painter/f-n-souza
    Vincent Karlof singer/vincent-karlof

    Paragraph
    In F. N. Souza's Disneyland’s Magic Kingdom, light cascades across the night sky before Alain Robbe-Grillet walks down through the stars. The castle that towers within the dark shines bright amongst the fireworks’ sparkling ceruleans and violets. Once the night show rises to a crescendo of color and song, the snaps of cameras coalesce with the symphony as Vincent Karlof strives to capture the moment in time with his melody.

    This will run on a loop till the last filled cell and I would like to identify the names found, in a separate row with pipe-separators.

    How can I do that?

  2. #2
    Valued Forum Contributor
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    968

    Re: VBA to replace multiple values with VLookup in hyperlink form

    Hi mnmtkr_18 & welcome to the forum

    If you post a sample file along with the expected results you'll probably get responses to your post. Refer to the yellow banner at the top of the page on how to attach a sample file

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 11-08-2014, 06:04 AM
  2. using VBA Vlookup to replace cell values?
    By dinosaur1993 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-15-2013, 06:09 PM
  3. [SOLVED] Faster way to find and replace multiple values with corresponding values
    By babbeleme1 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-18-2013, 06:50 PM
  4. Hyperlink vlookup and some copy paste values. Please help.
    By m_oioisju in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-07-2012, 12:55 PM
  5. Replies: 2
    Last Post: 02-06-2012, 01:43 PM
  6. Mutiple values to replace with multiple values random in fields
    By CatalinNic in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-18-2011, 01:52 PM
  7. Excel 2007 : How do I get multiple values form a vlookup
    By Icehockey44 in forum Excel General
    Replies: 9
    Last Post: 08-30-2011, 09:56 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1