problem formula Index not work after point to relation many column
Results 1 to 6 of 6

Thread: problem formula Index not work after point to relation many column

  1. #1
    New Member
    Join Date
    Sep 2012
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Unhappy problem formula Index not work after point to relation many column

    https://uppic.cc/v/K3i1Dear Friend
    I has problem about problem formula Index not work after point to relation many column
    Kindly help me about it from file att
    Thank you
    lotto009
    Last edited by lotto009; May 19th, 2019 at 05:52 AM. Reason: add photo

  2. #2
    Board Regular
    Join Date
    Aug 2015
    Posts
    766
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    1 Thread(s)

    Default Re: problem formula Index not work after point to relation many column

    Can you provide a real file not image and what the expected outcome is ?

  3. #3
    New Member
    Join Date
    Sep 2012
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: problem formula Index not work after point to relation many column

    =INDEX(F2:I2,MATCH(B3,D3:D12,0),MATCH(b4,E3:E12,0)),MATCH(b5,F3:I12,0))
    This is my formula but not work please help
    As below is link can access
    Thank you for kindly support
    https://mega.nz/#!Uo0XXK4B!eQbjLhB65...GmRaub7gxqMJl8
    Last edited by lotto009; May 19th, 2019 at 06:21 AM. Reason: upload file

  4. #4
    Board Regular
    Join Date
    Aug 2015
    Posts
    766
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    1 Thread(s)

    Default Re: problem formula Index not work after point to relation many column

    Hi

    B6=SUMPRODUCT(($D$3:$D$12=B3)*(E3:E12=B4)*(F2:I2=B5)*(F3:I12))

  5. #5
    New Member
    Join Date
    Sep 2012
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: problem formula Index not work after point to relation many column

    Quote Originally Posted by MARZIOTULLIO View Post
    Hi

    B6=SUMPRODUCT(($D$3:$D$12=B3)*(E3:E12=B4)*(F2:I2=B5)*(F3:I12))
    WOWWWWW so fast Thank you for kindly help me because I stuck this formals so long time
    Thank you krabbb K.MARZIOTULLIO
    l

  6. #6
    Board Regular
    Join Date
    Aug 2015
    Posts
    766
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    1 Thread(s)

    Default Re: problem formula Index not work after point to relation many column

    You are welcome.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •