Results 1 to 9 of 9

Trouble with Index-Match getting #REF!

Threaded View

  1. #1
    Registered User
    Join Date
    10-29-2013
    Location
    Brisbane, Australia
    MS-Off Ver
    office 365
    Posts
    42

    Trouble with Index-Match getting #REF!

    Hi guys,
    Having trouble with a formula. I have attached my work sample and in "sheet 1" I have highlighted the errors in red. I believe my error has something to do with the length of the first equation being only 6 samples long as the following columns data shows only 6 answers before the #REF! shows.
    My formula I am using is
    =INDEX((INDEX(Sheet2!$P$1:Sheet2!$P$300,Sheet2!$U$1):INDEX(Sheet2!$P$1:Sheet2!$P$300,Sheet2!$U$2)),MATCH(A2,Sheet2!$O$1:Sheet2!$O$300,0))
    which is the equation for cell B2, then copied down.
    For cell D2,the equation is
    =INDEX((INDEX(Sheet2!$P$1:Sheet2!$P$300,Sheet2!$U$2):INDEX(Sheet2!$P$1:Sheet2!$P$300,Sheet2!$U$3)),MATCH(C2,Sheet2!$O$1:Sheet2!$O$300,0))
    , then copied down.
    Data is exported from sheet 2.
    Thanks for all help.
    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. [SOLVED] Sumif + Index + Match Trouble
    By simple? in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-13-2013, 04:01 PM
  2. Trouble with index/match formula
    By mstar93 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-05-2013, 08:27 PM
  3. [SOLVED] INDEX MATCH Trouble
    By jjislas in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-27-2013, 03:46 PM
  4. [SOLVED] Trouble with Index and match formula
    By mdot218 in forum Excel General
    Replies: 2
    Last Post: 04-03-2012, 10:41 AM
  5. INDEX(...MATCH(IF...))) Function trouble
    By reaper_2 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-25-2011, 02:19 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