+ Reply to Thread
Results 1 to 2 of 2

INDEX / MATCH Formula Not Working

  1. #1
    Registered User
    Join Date
    07-04-2012
    Location
    Sunshine Coast
    MS-Off Ver
    Excel for Mac 2011
    Posts
    83

    INDEX / MATCH Formula Not Working

    I can not get the following formula working

    Formula: =INDEX(D8:F13,MATCH(D5&E5,D8:D13&E8:E13,0),3)

    I have attached my worksheet

    Thanks in Advance!!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    07-04-2012
    Location
    Sunshine Coast
    MS-Off Ver
    Excel for Mac 2011
    Posts
    83

    Re: INDEX / MATCH Formula Not Working

    Sorry, I now have it working!! I could not get it working on the same page (realised I just hit enter)
    However when referencing data on another tab, it would not work - But now it is!!

+ 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 formula not working
    By ea223 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-28-2023, 11:30 AM
  2. Correct/Working (Index,Match) formula not working between cells
    By barnerd in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 02-11-2014, 01:20 PM
  3. Index Match formula doesn't seem to be working
    By ortmandj in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-17-2013, 08:04 PM
  4. [SOLVED] index match formula not working
    By djmatok in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-19-2012, 11:12 AM
  5. Index - Match - ROWS formula not working?
    By marvinlajiant in forum Excel General
    Replies: 5
    Last Post: 10-12-2011, 11:26 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