Results 1 to 4 of 4

#Ref error with formula using Index & 2 matches

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-08-2015
    Location
    Asheville NC
    MS-Off Ver
    Excel for Office 365 MSO
    Posts
    111

    #Ref error with formula using Index & 2 matches

    I have a spread sheet where I am trying to use a index and 2 matches to return data from another cell. I keep getting a # ref error and don't understand why. I've tried changing the values to General, text, numbers and still can't figure it out.
    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: 2
    Last Post: 01-22-2016, 06:30 AM
  2. Need Advice on Formula Index+Match (Multiple Matches) + IF
    By cychua in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-05-2013, 05:08 AM
  3. [SOLVED] INDEX MATCH array formula that matches substring n gives multiple matches
    By bkwins in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-12-2013, 04:57 AM
  4. Replies: 7
    Last Post: 04-11-2013, 12:46 AM
  5. [SOLVED] Index Formula with Multiple Matches
    By amyj22x3 in forum Excel General
    Replies: 6
    Last Post: 12-11-2012, 10:48 AM
  6. Replies: 4
    Last Post: 07-18-2012, 02:34 PM
  7. Excel 2007 : Index Formula and Four Matches
    By papgar in forum Excel General
    Replies: 11
    Last Post: 01-24-2011, 12:55 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