+ Reply to Thread
Results 1 to 3 of 3

index match match - issue

  1. #1
    Forum Contributor
    Join Date
    11-26-2010
    Location
    usa
    MS-Off Ver
    Office 365
    Posts
    1,224

    index match match - issue

    hello

    i have the following index, match formula.

    i have to 2 criterias that im trying to use however the formula is not working 100% correctly. any thoughts?

    =INDEX(D6:O10,MATCH(C19,$D$5:$O$5,0),MATCH(B20,$C$6:$C$10,0))

    i have attached a sample.

    basically, i want to filter by "period or month" and then by "week" to give me the value in a cell.

    thx u in advance.

    cheers
    Attached Files Attached Files
    Last edited by jw01; 11-27-2012 at 03:53 PM.

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: index match match - issue

    =index($d$6:$o$10,match(b20,$c$6:$c$10,0),match(c19,$d$5:$o$5,0))

  3. #3
    Forum Contributor
    Join Date
    11-26-2010
    Location
    usa
    MS-Off Ver
    Office 365
    Posts
    1,224

    Re: index match match - issue

    *DUH* oh wow, i just had to rejig them...i had a feeling!

    thxs for the prompt response/help

+ 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