+ Reply to Thread
Results 1 to 2 of 2

Lookup names that have different ordering/sequence

  1. 06-06-2016, 10:01 PM #1
    trafsc119
    trafsc119 is offline
    Registered User
    Join Date
    06-06-2016
    Location
    Boston, Mass
    MS-Off Ver
    2013
    Posts
    1

    Lookup names that have different ordering/sequence

    Hello,

    I am trying to lookup (or other function/formula) names from two separate spreadsheets, but they are currently in a formats/orders.

    Example - On one sheet the names are listed John Doe. On the other sheet they are listed Doe, John. How can I get these cells similar or identical so that I can perform a vlookup (or other formula/function) off of them to pull in additional information?

    Thanks!
    B
    Reply With QuoteRegister To Reply
  2. 06-06-2016, 10:07 PM #2
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Lookup names that have different ordering/sequence

    This formula will reverse the name order and remove the comma:

    A1 = Doe, John

    =MID(A1&" "&A1,FIND(",",A1)+2,LEN(A1)-1)

    Returns: John Doe
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Ordering Names Based On Values in Other Cells
    By robertwclark in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-24-2014, 08:11 PM
  2. [SOLVED] How to lookup a code prefix from another page and autofill with an alphanumeric sequence
    By knitterjen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-25-2014, 04:47 AM
  3. VBA Ordering User form for Purchase Ordering.
    By caf20012 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 01-10-2014, 01:50 PM
  4. Ordering and Updating Numbers in a sequence
    By kglusing in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-29-2013, 10:42 AM
  5. Find\Lookup sequence of numbers in rows
    By WEBBOOO in forum Excel General
    Replies: 3
    Last Post: 06-28-2012, 08:24 AM
  6. Re-ordering a number sequence
    By Chameleonclaude in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-16-2010, 03:04 PM
  7. Sequence of control names in an array
    By bdn435 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-23-2007, 05:22 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1