Results 1 to 21 of 21

Find value that doesn't match and bring back column heading

Threaded View

  1. #1
    Registered User
    Join Date
    06-21-2014
    Location
    Sydney
    MS-Off Ver
    2011
    Posts
    92

    Find value that doesn't match and bring back column heading

    I have data for 2 years across 2 tabs
    5 columns of data to match

    How do I match the values in each column for both years (across 2 tabs) and then bring back the title of the column with the non matching value?

    Spreadsheet example attached

    Please let me know if its not clear enough

    Its going to be a large spreadsheet so an array formula would be best

    In my actual data I am using: =IF(ISNA(INDEX('2013 ADL'!$AZ$2:$AZ$18365,MATCH(1,INDEX((E2='2013 ADL'!$A$2:$A$18365)*(O2='2013 ADL'!$J$2:$J$18365)*(I2='2013 ADL'!$D$2:$D$18365)*(K2='2013 ADL'!$F$2:$F$18365)*(M2='2013 ADL'!$H$2:$H$18365),0),0))),"No Match","Match")

    This only tells me when everything matches or not

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Array Formula Lookup - Bring back Lowest Date + Bring Back Cell Location
    By Matt1998 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-04-2014, 12:08 PM
  2. Replies: 9
    Last Post: 10-22-2012, 02:03 PM
  3. Match two cells and bring back the results from a third
    By amyj22x3 in forum Excel General
    Replies: 3
    Last Post: 10-28-2011, 12:50 PM
  4. Find Lowest Time, Match with Column Heading
    By nadler1744 in forum Excel General
    Replies: 1
    Last Post: 07-08-2009, 01:17 AM
  5. How do I bring back my worksheet tabs in Excel. Options doesn't
    By Grenier in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-21-2006, 12:55 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