Results 1 to 5 of 5

Replacing partial customer names in List1 with matching full names from List2...

Threaded View

  1. #1
    Registered User
    Join Date
    04-04-2016
    Location
    Bucharest, Romania
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2210 Build 16.0.15726.20188) 32-bit
    Posts
    22

    Replacing partial customer names in List1 with matching full names from List2...

    In list 1, the names are in the order in which customers placed orders, while in the second list, they are in alphabetical order and include full names. I don't have the ability to sort the first list by a criterion, I received them already sorted.
    Question: How can I replace each customer name in the first list, where it doesn't have the full name, with the corresponding name from the second list, but keep the order of the names in the first list?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need Excel VBA to categorize product from list1 to list2 by filter multiple values
    By astray88 in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 03-07-2023, 11:42 PM
  2. [SOLVED] Replacing list of usernames with matching real names
    By joe_schmo95 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-27-2020, 01:22 PM
  3. Matching Abbreviated names and Full names
    By s15 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-22-2015, 06:37 PM
  4. Comparing two lists and printing elements of list1 that are not in list2+3
    By Nazariy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-16-2014, 11:20 AM
  5. Replies: 4
    Last Post: 03-19-2011, 11:56 AM
  6. List2 based on List1
    By Hasnain in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-10-2008, 03:45 AM
  7. I have a list1 and a list2, I want to remove list2 from list1
    By snow in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-19-2006, 02:00 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