Results 1 to 3 of 3

Thread: Vlookup formula for 3 criteria

  1. #1

    Vlookup formula for 3 criteria



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,

    Please could someone kindly assist.
    I am battling to create a formula that uses three criteria to lookup a value.

    I have attached a simple spreadsheet, that shows the layout of my current data and what the end result should be.

    Any assitance would be greatly appreciated. This is taking me a while to figure out.

    Many thanks.
    Attached Files Attached Files

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,508
    Articles
    0
    Excel Version
    Excel 2016
    Try:

    =SUMIFS(INDEX(C8:K10,MATCH(C16,B8:B10,0),0),C6:K6,C17,C7:K7,C18)


  3. #3
    Acolyte Jean Paul's Avatar
    Join Date
    May 2015
    Posts
    22
    Articles
    0
    Excel Version
    2013
    Try this
    =SuMPRODUCT((C6:K6=C17)*(C7:K7=C18)*(B8:B10=C16)*C8:K10)

Posting Permissions

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