+ Reply to Thread
Results 1 to 2 of 2

Matching To Nearest Name VBA

  1. #1
    Forum Contributor
    Join Date
    05-09-2014
    MS-Off Ver
    Excel 2017
    Posts
    300

    Matching To Nearest Name VBA

    Hi,
    I need a macro button on sheet 1 that will match the nearest name from Sheet 1 Column A to Sheet 2 Column A and put the correct image links in alphabetical order. I have done the first 3 rows on sheet 1 as an example.

    I attached the sheet, please let me know if any questions.

    Help is greatly appreciated!
    Attached Files Attached Files

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,910

    Re: Matching To Nearest Name VBA

    Define "nearest name." I'm not going to reverse engineer all the rules for you, but it seems like

    Take the first name before the space. Look at everything after the slash. If it has a dash take what is before the dash.

    So AARON BLACKOUT365 GROMMET PAIR PANEL /BLUE becomes AARON*BLUE & ".jpg" and this matches Aaron*Blue.jpg

    However, how do I decide which one of these goes with: https://www.dropbox.com/sh/9y6bfij19...aheemI9va/Lala Bash/ADDYSON_Pole Top_White.jpg?dl=0?
    ADDYSON FAUX LINEN POMPOM POLE TOP PAIR PANEL /WHITE-WHITE
    ADDYSON FAUX LINEN POMPOM POLE TOP PAIR PANEL /WHITE-MULTI

    You will have to fully define the rules and exceptions before anyone can program it. This is Excel, not AI.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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. Looking up matching or nearest match
    By tonykyte in forum Excel General
    Replies: 1
    Last Post: 02-04-2018, 04:18 AM
  2. Replies: 18
    Last Post: 10-08-2017, 04:17 AM
  3. [SOLVED] Alter Matching Sub From matching two Ranges to matching one range and list
    By capson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-14-2015, 10:48 PM
  4. Matching with a nearest date in a date range?
    By mrxlsx in forum Excel General
    Replies: 2
    Last Post: 05-05-2015, 01:23 PM
  5. Round to nearest 15 then nearest hour if less than 1 hour
    By BLOUNTFIRE in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-08-2014, 12:22 AM
  6. [SOLVED] Round Cell to Nearest 0.25 up-to 1.0 then to nearest 0.5
    By haynesc87 in forum Excel General
    Replies: 4
    Last Post: 05-30-2012, 01:38 PM
  7. Nearest matching co-ordinates
    By stevow in forum Excel General
    Replies: 1
    Last Post: 12-06-2011, 02:08 PM

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