+ Reply to Thread
Results 1 to 6 of 6

Multiple criteria Lookup Value

  1. #1
    Registered User
    Join Date
    08-24-2011
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    9

    Multiple criteria Lookup Value

    Hey,
    Whats wrong with this formula.
    I'm tying to look for value in D3 from array I:L with 3 condition lookup/Match.
    Please helpUntitled.png
    Attached Files Attached Files

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    6,033

    Re: Multiple criteria Lookup Value

    Try this =SUMPRODUCT(--($I$2:$I$16=A2)*--($J$2:$J$16=B2)*--($K$2:$K$16=C2)*$L$2:$L$16) and pull down as needed
    Attached Files Attached Files

  3. #3
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO200;Win10/MSO2016
    Posts
    10,096

    Re: Multiple criteria Lookup Value

    Please Login or Register  to view this content.
    ...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
    Ben Van Johnson

  4. #4
    Registered User
    Join Date
    08-24-2011
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Multiple criteria Lookup Value

    Thnx, such a help this was

  5. #5
    Registered User
    Join Date
    08-24-2011
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Multiple criteria Lookup Value

    protonLeah Doesn't work when i paste the same to next cell
    Last edited by amjad831001; 01-10-2019 at 06:41 AM.

  6. #6
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO200;Win10/MSO2016
    Posts
    10,096

    Re: Multiple criteria Lookup Value

    protonLeah Doesn't work when i paste the same to next cell...
    Paste?

    You are supposed to use the fill handle
    Attached Files Attached Files

+ 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