Results 1 to 6 of 6

INDEX/MATCH formula help

Threaded View

  1. #1
    Registered User
    Join Date
    02-02-2005
    Posts
    51

    INDEX/MATCH formula help

    I have attached a sample of data, it may be easier to understand what I am trying to accomplish.

    Need to match the trace# on two different tabs and see if the $ amounts match.

    I would like to add a formula in column S on sheet 1 and look up the Trace# from column P
    and go to Sheet 2 to find the same trace # and compare the $ amounts.

    If the amount matches show "Amount Matched" , otherwise "Not Matched"

    VLOOKUP did not work since the amount on sheet 2 is to the left of the trace number.

    In the example attached the formula should show Not Matched since the same trace number does not have the same amount
    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. Replies: 5
    Last Post: 10-16-2016, 02:33 AM
  2. [SOLVED] This formula works but I donīt understand why Index(Index) match
    By campelliann in forum Excel General
    Replies: 2
    Last Post: 01-25-2016, 05:55 PM
  3. Replies: 2
    Last Post: 09-27-2014, 04:34 PM
  4. Index Match Match Formula DOESN'T WORK WITH TABLES/TABLE NAMES ??
    By Underling in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-04-2014, 09:01 PM
  5. Replies: 3
    Last Post: 05-02-2013, 01:31 AM
  6. Index Match Index Formula work slow
    By avk in forum Excel General
    Replies: 9
    Last Post: 03-07-2012, 02:19 PM
  7. Replies: 5
    Last Post: 02-29-2012, 08:51 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