Results 1 to 8 of 8

Formula to Display Values Based on 2 Criteria

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-10-2016
    Location
    Minneapolis, Minnesota
    MS-Off Ver
    Office 365
    Posts
    124

    Formula to Display Values Based on 2 Criteria

    Hi,

    I have attached a sample spreadsheet to better explain what needs to happen.
    In the spreadsheet, I have a table that is generated by SQL. Form this table I need to pull out certain sections. The Sections that I need to pull out are in the table next to it in yellow.
    I need to type in base (in this case W128636; This will populate the table) and SubNo (in this case 5), the result needs to be a list of rsc.

    I have tried the following array: {=IFERROR(INDEX($E$2:$E$41,MATCH(0,IF($H3=$C2:$C41,COUNTIF($H3:H3,$E$2:$E$41),""),0)),"")}
    This array work except it removes all duplicates and I need it to display everything preferably in a column (highlighted in yellow) instead of a row.

    (BASE WILL NEVER CHANGE, ONLY subNo)

    Thank you
    Attached Files Attached Files
    Last edited by YuriyBaron; 07-01-2018 at 11:09 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Display values from a second Worksheet in a userform based on Criteria
    By anthony1312002 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-12-2018, 10:02 AM
  2. Replies: 8
    Last Post: 04-17-2016, 01:21 PM
  3. Replies: 1
    Last Post: 11-09-2014, 06:04 PM
  4. [SOLVED] Lookup and display values in order based on different date criteria.
    By sandman85 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-13-2014, 02:57 AM
  5. [SOLVED] Formula to display contacts based on common criteria
    By Blubirdjim in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-19-2012, 11:31 AM
  6. Replies: 3
    Last Post: 02-06-2012, 04:55 PM
  7. How to display all values based on one criteria
    By cojast in forum Excel General
    Replies: 2
    Last Post: 07-02-2008, 01:54 PM

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