+ Reply to Thread
Results 1 to 2 of 2

Help me match two sets of data

Hybrid View

  1. #1
    Registered User
    Join Date
    01-13-2015
    Location
    england
    MS-Off Ver
    dont know
    Posts
    4

    Unhappy Help me match two sets of data

    Hey guys, hoping you can help with this simple problem

    in my spreadsheet, from one of the data tables I have Column B with "invoice number" as a heading and Column E with "PO number" as a heading.

    I need to match the contents of one of these two fields to column M, which has a mixture of the two.
    ideally I'd like matched pairs to be filled in with a color, such as yellow


    also I need to remove a "-" from all the contents of column M so it is in the same format as the contents of column B (E.g 201454 and 2014-54)


    any help is appreciated.

    many thanks

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Help me match two sets of data

    Hi and welcome to the forum.

    Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

    Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

    Incidentally if you don't know your MS or Excel versions maybe you should find out. Often the answers we give here rely on knowing this.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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. Need to match up data from two different sets.
    By kwarpinski3 in forum Excel General
    Replies: 2
    Last Post: 11-08-2013, 09:30 AM
  2. Match Two Sets of Data
    By dkang2007 in forum Excel General
    Replies: 7
    Last Post: 07-22-2013, 12:08 PM
  3. Match Up Two Sets of Data
    By Zwnd in forum Excel General
    Replies: 1
    Last Post: 07-14-2012, 06:02 PM
  4. [SOLVED] vba Match Two Sets of Data
    By timbo1957 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-22-2011, 04:58 AM
  5. How to match two sets of data between two worksheets
    By humptydumpty in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-07-2010, 04:48 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