Results 1 to 7 of 7

A lookup function based on two criteria; one unique & one not unique to the lookup table

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-16-2012
    Location
    Brooklyn
    MS-Off Ver
    Excel 2010 PC
    Posts
    137

    A lookup function based on two criteria; one unique & one not unique to the lookup table

    Hi,
    I have a problem I'm stuck on. I'm trying to create a lookup formula based on two criteria. The first "category" criteria is a unique value while the second, "characteristic" criteria is not unique to the lookup table/array. I've attached an example sheet but will also include example text below:

    ''''''''''''''''''''''''''''''''''''''
    Category 1
    alpha
    beta
    Category 2
    alpha
    beta
    gamma
    Category 3
    beta
    epsilon
    '''''''''''''''''''''''''''''''''''''
    The lookup I'm trying to make would return, for example: Category 2 beta

    Any insight into this problem is greatly appreciated.

    Thank you
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Count unique entries based off unique criteria in another column
    By hambly in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 06-11-2014, 03:33 PM
  2. [SOLVED] Two Criteria Lookup, with two seporate criteria making a unique identifier.
    By Trevasaurus in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-26-2013, 11:00 AM
  3. Replies: 13
    Last Post: 12-19-2012, 02:38 PM
  4. Multiple Criteria lookup + Listing Unique information
    By arekkusu03 in forum Excel General
    Replies: 1
    Last Post: 09-14-2012, 03:27 AM
  5. Lookup Unique based on Multiple Conditions
    By statenja in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-05-2009, 09:31 AM

Tags for this Thread

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