+ Reply to Thread
Results 1 to 11 of 11

Multi condition lookup

Hybrid View

  1. #1
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    19,039

    Re: Multi condition lookup

    It is coded to return blanks where there is no match. For example there is no part# 1000 nor 1659 in the sample. Also the dates listed in the sample are January through May, so it returns blanks for June through December. I tested it with your sample and it returns the quantity for part#'s and months listed in O1:Q24

  2. #2
    Registered User
    Join Date
    04-10-2015
    Location
    Detroit
    MS-Off Ver
    2010
    Posts
    14

    Re: Multi condition lookup

    Correct, however it is returning blanks for value that are there and should show up. Am I using your formula the right way?
    Book2.xlsx

+ 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. Multi-Condition Date Effective Lookup
    By rtgray in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-12-2015, 02:49 AM
  2. [SOLVED] multi drop down list with multi-lookup
    By civileng12 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-31-2012, 06:50 PM
  3. Lookup multi columns w/ multi answers
    By dec671 in forum Excel General
    Replies: 1
    Last Post: 01-28-2010, 04:48 PM
  4. multi condition format? lookup and date condition valid for.
    By D_Rennie in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-13-2009, 11:37 AM
  5. Multi Condition SUM
    By newone210 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-20-2006, 01:18 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