Results 1 to 3 of 3

Pull values using Non Array formula if conditions are met

Threaded View

bjnockle Pull values using Non Array... 09-10-2017, 07:18 PM
Root_ Re: Pull values using Non... 09-10-2017, 08:16 PM
humdingaling Re: Pull values using Non... 09-10-2017, 08:38 PM
  1. 09-10-2017, 07:18 PM #1
    bjnockle is offline
    Forum Contributor
    Join Date
    02-06-2013
    Location
    Maryland
    MS-Off Ver
    Excel 2010
    Posts
    1,012

    Pull values using Non Array formula if conditions are met

    Looking for non-array formula formula to pull values in sheet named Product into C5:F16 of Outcome sheet if conditions in B2:E2 are met. Sample file attached.

    Conditions:
    Region	Report Range I	Report Range II	 Year
North	          Jan	      Aug	 1991

    Month	Apple	Banana	Coconut	Mango
Jan	-	-	-	-
Feb	-	-	-	-
Mar	-	-	-	-
Apr	-	-	-	-
May	-	-	-	-
Jun	42%	32%	35%	37%
Jul	43%	72%	75%	29%
Aug	73%	37%	87%	72%
Sep				
Oct				
Nov				
Dec
    Attached Files Attached Files
    Last edited by bjnockle; 09-10-2017 at 07:24 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. Non Array Formula to pull unique values and sort in a range
    By bjnockle in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 02-04-2021, 06:15 AM
  2. Non Array formula to pull values if conditions met
    By bjnockle in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-26-2017, 05:47 AM
  3. [SOLVED] Pull non-blank, text values from array
    By c.bernardo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-23-2017, 12:08 PM
  4. Pull sub array from array using multiple column_num values
    By SinJinQLB in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-25-2015, 05:37 PM
  5. Need a formula to pull data from another tab with 2 conditions
    By hillnoft in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-25-2014, 04:02 PM
  6. [SOLVED] INDEX MATCH and MIN/SMALL to pull first and second smallest values from array
    By tlafferty in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-18-2014, 04:03 AM
  7. Pull row/column titles based on values inside an array
    By julzzzz in forum Excel General
    Replies: 1
    Last Post: 03-29-2012, 06:45 PM

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