+ Reply to Thread
Results 1 to 2 of 2

Index - Match Function -- Problem

  1. #1
    Registered User
    Join Date
    04-18-2004
    Posts
    7

    Index - Match Function -- Problem

    Hello:

    A - B - C - D - E - F
    1 - Data 2003 2004 2005 2006 2007
    2 - DE 57 61 64 65 65
    3 - MD 55 59 62 62 62
    4 - NJ 47 47 47 47 48
    5 - NY 37 40 41 39 39
    6 - PA 41 43 45 46 48

    I have the data arranged as above:

    I need only selected values such as

    cell I1: 2004
    cell H2: DE ????


    I write the following array function:

    {=INDEX($C$2:$C$6,MATCH($H2&I$1,$A$2:$A$6&$B$1:$F$1,0))}

    It gives me #N/A in stead of the actual value 61 - in cell C2.

    What is the mistake

    Thank you.
    Subbu
    [email protected]
    Last edited by VBA Noob; 05-15-2008 at 05:22 PM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474
    Try This ,
    =INDEX($A$1:$F$6,MATCH(H2,$A$1:$A$6,0),MATCH(I1,$A$1:$F$1,0))

    it is not an array formula,
    A1:F6 is considered the range of your data

+ Reply to Thread

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