Results 1 to 6 of 6

Index - Match - ROWS formula not working?

Threaded View

  1. #1
    Registered User
    Join Date
    07-27-2011
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    14

    Index - Match - ROWS formula not working?

    Hi
    i tried to do an index(array(match) formula, however the result always gives me an error (#NA)

    here's the formula i entered:

    =INDEX(Table!$A$1:$D$9,MATCH(C1,Table!$A$1:$A$9,0),MATCH(B1,Table!$A$1:$D$1,0))

    the column match formula works fine, however the row match formula does not

    i have attached the file i was working on, and the errors are highlighted in yellow

    can i please get some guidance on this? have formatted the figures to numbers & text (and vice versa) but it still will not work...

    thanks in advance

    Marvin
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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