Results 1 to 6 of 6

Non Array to extract values if condition is met

Threaded View

bjnockle Non Array to extract values... 04-27-2021, 07:59 PM
Phuocam Re: Non Array to extract... 04-27-2021, 08:24 PM
bjnockle Re: Non Array to extract... 04-27-2021, 08:28 PM
Phuocam Re: Non Array to extract... 04-27-2021, 08:45 PM
bjnockle Re: Non Array to extract... 05-07-2021, 07:30 AM
XLent Re: Non Array to extract... 05-07-2021, 07:45 AM
  1. 04-27-2021, 07:59 PM #1
    bjnockle is offline
    Forum Contributor
    Join Date
    02-06-2013
    Location
    Maryland
    MS-Off Ver
    Excel 2010
    Posts
    1,012

    Non Array to extract values if condition is met

    Looking for non-array formula to look into A2:C10 and extract the correct values using E1 as the requirement to pull values into G2:G6 and H2:H6. Desired outcome is in G2:G6 and H2:H6. See sample file.

    Requirement: E1: Feb, Mar

    Thanks
    Attached Files Attached Files
    Last edited by bjnockle; 04-27-2021 at 08:02 PM.
    Reply With QuoteRegister To Reply
« 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. Extract Values from F15:S20 into F3:S10 if Condition Met
    By bjnockle in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 04-26-2021, 11:52 PM
  2. Extract Values into Column F if Condition is Met
    By bjnockle in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-08-2021, 09:22 PM
  3. Extract Values If Condition is Satisfied
    By bjnockle in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-11-2021, 04:40 AM
  4. Extract values with non-array formula if condition met
    By bjnockle in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-02-2020, 08:14 PM
  5. Extract values based on one condition
    By bjnockle in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-26-2017, 04:24 AM
  6. [SOLVED] Extract values with condition (VBA)
    By izk630 in forum Excel General
    Replies: 3
    Last Post: 01-24-2017, 04:51 PM
  7. Extract corresponding multiple values after the condition is met
    By akshay20 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-23-2015, 09:24 AM

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