Results 1 to 8 of 8

Index Match Error

Threaded View

  1. #1
    Registered User
    Join Date
    02-17-2005
    Posts
    7

    Index Match Error - Updated with Formula!!

    The formula that I have works when the match is a two digit number, but not for a one digit number. Can anyone think of any reason why?

    =IF(ISERROR(INDEX('[Dept Class - FY 2007 Feb.xls]345'!$A$11:$G$2000,MATCH($N$95&$A108,'[Dept Class - FY 2007 Feb.xls]345'!$A$11:$A$2000&'[Dept Class - FY 2007 Feb.xls]345'!$B$11:$B$2000,0),4,1)),0,INDEX('[Dept Class - FY 2007 Feb.xls]345'!$A$11:$G$2000,MATCH($N$95&$A108,'[Dept Class - FY 2007 Feb.xls]345'!$A$11:$A$2000&'[Dept Class - FY 2007 Feb.xls]345'!$B$11:$B$2000,0),4,1))

    A B C D
    55 8 96 780
    55 9 140
    55 10 390
    55 11 745 2430

    The problem is matching on column B, returning column D. $N$95 is 55, and $A108 is the value of column B. This formula will return 2430, but not 780.
    Last edited by dfab100; 04-19-2007 at 12:29 PM.

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