+ Reply to Thread
Results 1 to 2 of 2

Multiple Values (filters)

  1. 03-14-2025, 10:30 AM #1
    Jmwjags
    Jmwjags is offline
    Registered User
    Join Date
    01-09-2025
    Location
    North Carolina, United States
    MS-Off Ver
    Office 365
    Posts
    9

    Multiple Values (filters)

    I am trying to return certain cells based on 2 values.
    IN cell a5, i want to return the value of cells from another sheet.

    Cell B1 is a # and cell g2 is a customer.

    B1 = A product # from sheet 2 in cells L13-L18
    G2 = The customer from sheet 2 in cell J3

    Cell T2 is where the current formula pulls from.
    I'd like it to pull from T2=AW2 based on the value in T1-AW1 if it matches sheet 1 B1 & G2

    ROWS N-AW on sheet 2 remain hidden at all times.

    Book1A.xlsx
    Reply With QuoteRegister To Reply
  2. 03-14-2025, 11:21 AM #2
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2505
    Posts
    27,272

    Re: Multiple Values (filters)

    There is nothing in cell G2. It appears that the customer is in D1.

    Is T1:AW1 in Sheet2 a list of product numbers? I can't see how to map your product numbers in column L with what is in columns T:AW.

    See solution in my copy of your sheet.

    Please do not use merged cells. I removed the merged cells and you can see my solution has the same appearance.

    You will have to adjust the formula to account for the actual number of rows on Sheet2.
    Attached Files Attached Files
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Creating a dynamic table that filters based on multiple data validation filters
    By pfusella in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 05-18-2025, 01:39 AM
  2. How to apply multiple and independent filters for pivot table values?
    By dejavu619 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-08-2021, 05:17 AM
  3. Macro to update a pivot table containing multiple filters (not multiple items in a filter)
    By phrankndonna in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-16-2020, 06:35 PM
  4. [SOLVED] Macro to select multiple pivot table filters, based on values in a table
    By Portuga in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-03-2018, 06:42 PM
  5. Applying multiple values filters on a single variable (pivot table)
    By greengirl in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-29-2015, 08:24 PM
  6. Help Needed to get Filters Using "Include" and "Exclude" multiple values on one column.
    By alfykunable in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-23-2012, 04:03 AM
  7. Multiple Workbook booking system - filters into 1 main book which filters into another...
    By joshnathan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-24-2012, 01:21 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1