+ Reply to Thread
Results 1 to 2 of 2

Array that returns multiple results matching a date

Hybrid View

  1. #1
    Registered User
    Join Date
    09-21-2021
    Location
    Dayton, Ohio
    MS-Off Ver
    Excel 2016
    Posts
    1

    Array that returns multiple results matching a date

    In the "Apr" tab, in cell D37, I have the date April 12, 2022. In the "Crop List" tab, I have a table called "Crops". I'm trying to create a formula that matches the date in cell D37 to every instance of that date in columns D and F in the "Crops" tables. If the date is in column D, I want it to return the value in column G. If the date is in column F, I want it to return the value in column H. I've used INDEX, AGGREGATE, MATCH, combinations of those, etc. Still can't get it to work. Any suggestions or directions?April tab.PNGCrop List tab and Crops table.PNG

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,684

    Re: Array that returns multiple results matching a date

    See yellow banner on how to attach a sample workbook.

+ 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-03-2021, 06:08 PM
  2. Replies: 1
    Last Post: 01-18-2019, 03:55 PM
  3. [SOLVED] StDev formula using array returns incorrect results
    By Elgin26 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-29-2018, 11:01 AM
  4. Array formula returns erroneous results
    By RJK in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-22-2017, 01:25 PM
  5. [SOLVED] Matching Lists to Array to get Results
    By Excell1677 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-31-2016, 09:59 PM
  6. Replies: 9
    Last Post: 07-14-2016, 06:44 AM
  7. [SOLVED] ARRAY Formula matching LARGE, getting duplicated results
    By Ricardo Mass in forum Excel General
    Replies: 9
    Last Post: 03-10-2014, 09:04 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