+ Reply to Thread
Results 1 to 3 of 3

Match-Index in stead of Index-Match lookup Array among Arrays

  1. #1
    Registered User
    Join Date
    04-26-2014
    Location
    Belgium
    MS-Off Ver
    Excel 2003
    Posts
    12

    Match-Index in stead of Index-Match lookup Array among Arrays

    Dear all,

    For a particular sheet i'm supposed to find the corresponding array out of a list of array's, but only if the title of the array corresponds.
    In the grey box should be written Dog or Cat for example, and then the corresponding array should be copied into the box.

    Map1.xlsx

    Is this douable with a Match-index function? I tried several approaches with Index(;Match()) but it failed

    Thanks
    Numnum

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 2003, 2010, 2016 (Windows)
    Posts
    4,720

    Re: Match-Index in stead of Index-Match lookup Array among Arrays

    You need to use a formula like

    =INDEX($C$11:$H$30,MATCH($C$3,$C$11:$C$30,FALSE)+ROW(A2),COLUMN(A1))

    as in the attached:

    Map1.xlsx
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Registered User
    Join Date
    04-26-2014
    Location
    Belgium
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: Match-Index in stead of Index-Match lookup Array among Arrays

    Thank you for the quick response, this worked flawlessy.
    I tried to use =INDEX((C14:H17,C23:H26,C30:H33),MATCH($C$3,$C$12:$C$28,0),,V.LOOKUP($C$3,$J$5:$K$7,2)) but then it responded the bird array instead of the dog array.

    Seems I have still to learn a lot about this function.

    Greetings

+ 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] Double Index Match by Indirect Lookup Arrays
    By Erickson28 in forum Excel General
    Replies: 18
    Last Post: 07-30-2015, 12:46 PM
  2. Lookup OR Index/Match with multiple Array's
    By Numnum in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-05-2014, 05:32 AM
  3. Replies: 6
    Last Post: 04-30-2014, 02:42 AM
  4. Lookup, Index, Match, Array Help
    By Reaye in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-06-2013, 03:36 PM
  5. [SOLVED] Index & Match returning incorrect value. Arrays fixed and exact match used.
    By SDes in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-07-2012, 08:29 PM
  6. Replies: 7
    Last Post: 06-19-2011, 12:51 PM
  7. table, index, array, match, lookup?
    By spxer in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-08-2006, 04:35 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