+ Reply to Thread
Results 1 to 2 of 2

Match Date and Amount in two sheets and if equal replace bad entry

  1. #1
    Registered User
    Join Date
    10-09-2011
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    39

    Match Date and Amount in two sheets and if equal replace bad entry

    I’m really a novice at XL and I’ve come upon a problem is that beyond my scope of knowledge. The payee has gotten messed up such that when I run a pivot table the formatting is messed up by having multiple payees that should appear in one entry but there are several entries because of the mismatch of the payees. There are thousands of entries so doing it by hand would take me forever.

    What I need is a formula to match the date and amount in the goodpayee sheet with the date and amount in the bad payee sheet and if they match to replace the badpapyee with the goodpayee.

    Greg
    Attached Files Attached Files

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Match Date and Amount in two sheets and if equal replace bad entry

    Please see the attachment. It uses a helper column and index/match.
    Attached Files Attached Files
    Martin

+ 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. [SOLVED] Index Match equal to or less than date with multiple criteria
    By harrismlzn in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-19-2014, 05:38 PM
  2. Split the equal amount acoss months based on start and end date
    By Ktahilramani in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-07-2014, 11:18 PM
  3. [SOLVED] If reference A is in sheets 1 and 2, does the amount match exactly in both sheets?
    By MushroomFace in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-27-2013, 02:08 PM
  4. Replies: 2
    Last Post: 04-28-2013, 02:23 AM
  5. How to match Date and Amount from Sheet1 to Sheet2 with the same Date and Amount?
    By ims0phie in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-23-2013, 06:51 AM

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