+ Reply to Thread
Results 1 to 3 of 3

List a value using multiple criteria on a seperate worksheet

  1. #1
    Registered User
    Join Date
    09-15-2014
    Location
    u.s.a.
    MS-Off Ver
    excel 2013
    Posts
    2

    List a value using multiple criteria on a seperate worksheet

    Hello,

    I'm trying to lookup values in a list on a worksheet, based on multiple criteria from another worksheet. The list has several items, with each item using a division category and a building id number used for identification. See below:

    Worksheet 1:

    Criteria 1= cell A1= number (ex: 101101)
    Criteria 2= cell A2= number (ex: 2)

    Worksheet2:

    1 A B C D


    2 Description Qty Division Bldg

    3 Signage 2 101101 1

    4 Extinguisher 8 101400 2

    5 Concrete 4 101400 2

    Here's what I'm trying to do: If worksheet1 has a division number (ex: 101400) as criteria 1, and a building i.d. number for criteria 2 (ex: 2), how do I use these criteria to reference all the items in the list on worksheet2? Based on this example, I should get a list on worksheet1 that returns "Extinguisher" and "Concrete". I tried using a LOOKUP function, but I don't think it's possible because I'm using multiple criteria. I next tried using the functions INDEX and MATCH, but I'm not having any success. Anybody got any ideas? Thanks.

  2. #2
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,844

    Re: List a value using multiple criteria on a seperate worksheet

    If you post a workbook with sample data and the result you expect it will be much easier to help you.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  3. #3
    Registered User
    Join Date
    09-15-2014
    Location
    u.s.a.
    MS-Off Ver
    excel 2013
    Posts
    2

    Re: List a value using multiple criteria on a seperate worksheet

    Hi Jacc,

    Let me know if this attachment makes sense.

    Thanks

    Two criteria example.xlsx
    Last edited by Excelerino; 09-16-2014 at 10:22 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. Replies: 6
    Last Post: 02-28-2014, 09:34 AM
  2. Replies: 10
    Last Post: 03-04-2013, 09:02 AM
  3. [SOLVED] Need a Formula to return a list of data that matches 3 criteria in seperate columns
    By JDUBS1080 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-23-2013, 01:06 PM
  4. [SOLVED] List Multiple Criteria From Separate Worksheet
    By ajocius in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-30-2012, 03:29 PM
  5. List Worksheets in seperate worksheet
    By caoimhincryan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-28-2005, 11:05 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