+ Reply to Thread
Results 1 to 4 of 4

Cross Reference Numbers Help

  1. 09-25-2014, 10:46 AM #1
    Jeff73
    Jeff73 is offline
    Registered User
    Join Date
    07-12-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    9

    Cross Reference Numbers Help

    I am trying to figure out a quicker way of cross referencing numbers and hoping someone might be able to help. In column "A" is the number that groups the numbers in Column "B" together and Column "C" would be the result of the cross reference. Does anyone know a way I could make this more automatic? Thanks in advance for the help.

    A B C
    706 T013 T113,T713
    706 T113 T013,T713
    706 T713 T013,T113

    708 T005 T105,T705
    708 T105 T005,T705
    708 T705 T005,T105
    Last edited by Jeff73; 09-25-2014 at 10:55 AM.
    Reply With QuoteRegister To Reply
  2. 09-25-2014, 11:20 AM #2
    MickG
    MickG is offline
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Cross Reference Numbers Help

    With your Data starting in "A1" , Try this for results in column "C".
    Please Login or Register  to view this content.
    Regards Mick
    Reply With QuoteRegister To Reply
  3. 09-25-2014, 01:01 PM #3
    Jeff73
    Jeff73 is offline
    Registered User
    Join Date
    07-12-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Cross Reference Numbers Help

    Mick

    Thank you so much for the help! It worked perfectly!!

    Again, thank you for your help.
    Reply With QuoteRegister To Reply
  4. 09-25-2014, 01:33 PM #4
    MickG
    MickG is offline
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Cross Reference Numbers Help

    You're welcome
    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. [SOLVED] Cross reference with multiple instances in reference data
    By Nick F in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-08-2013, 10:31 AM
  2. How to cross reference two columns of numbers
    By Danexcel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-09-2010, 09:52 AM
  3. Cross-reference Date with Numbers
    By mckoy_1 in forum Excel General
    Replies: 7
    Last Post: 07-31-2007, 04:11 PM
  4. Cross Reference Part Numbers
    By Chuck N in forum Excel General
    Replies: 5
    Last Post: 09-18-2006, 08:53 PM
  5. [SOLVED] How can I cross reference phone numbers with existing phone numbe.
    By John in forum Excel General
    Replies: 1
    Last Post: 02-11-2005, 01:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1