+ Reply to Thread
Results 1 to 2 of 2

Need help with creating a multi-criteria lookup formula

  1. #1
    Registered User
    Join Date
    07-23-2015
    Location
    USA
    MS-Off Ver
    Office 2010 and 2011
    Posts
    1

    Need help with creating a multi-criteria lookup formula

    I need to pull a number from a column (Week #) but it has to match up with criteria from 3 other columns.

    1. Week (A:A) (column to pull from) 2. Code (B:B)(Criteria) 3. Year(C:C) (Criteria) 4. Occupancy (D:D) (Criteria).

    The code column has alphabetical input, such as CCC. The year column data is represented in terms of 2014 and the occupancy column is represented as in terms of 0.60, for example. B:B and C:C have to be exact matches but D:D needs to be in the MATCH form of "-1" (smallest value that is greater than or equal to the lookup value.) This is because D:D often does not have the exact number needed in the data set its being pulled from and the point of this is to be able to frequently swap out values to autofill a table. I need a function that will reference all 3 things and when they are all true, generate a number from column A:A.

    Thanks!

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,430

    Re: Need help with creating a multi-criteria lookup formula

    Try this formula:
    Please Login or Register  to view this content.
    Which has been applied to cell G5 in this file: Multi Criteria Lookup Formula.xlsx

    If this is not what you are looking for then please use the "Go Advanced" button to upload a sample, or desensitized, file that can be used to model a formula.
    Last edited by JeteMc; 07-24-2015 at 01:10 AM.

+ 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. Creating a Multi Criteria Filter using VBA
    By vbanoobz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-30-2014, 05:24 PM
  2. Help : Multi criteria with MATCH or LOOKUP formula
    By clonedarkman in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-20-2014, 10:47 AM
  3. Multi Criteria Lookup
    By jsabo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-27-2013, 02:06 AM
  4. Creating a multi criteria drop down
    By tanksalevikrant in forum Excel General
    Replies: 11
    Last Post: 12-15-2010, 07:17 AM
  5. Complex multi criteria lookup and count formula???
    By JapanDave in forum Excel General
    Replies: 9
    Last Post: 05-25-2009, 04:36 AM
  6. Multi criteria lookup
    By spot1960 in forum Excel General
    Replies: 2
    Last Post: 04-08-2008, 10:33 AM
  7. Multi Criteria lookup
    By epotter in forum Excel General
    Replies: 3
    Last Post: 07-05-2006, 07:35 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