+ Reply to Thread
Results 1 to 2 of 2

Find the first value in a column that is greater and and return cell next to it

  1. #1
    Registered User
    Join Date
    10-02-2019
    Location
    United States
    MS-Off Ver
    365
    Posts
    3

    Find the first value in a column that is greater and and return cell next to it

    Hi!

    As the title states, I am trying to find the first value in a column that is greater and return the cell next to it. In the attached document I am trying to have a formula in Sheet1 Column G that will look up on Sheet2 the date that is in Sheet1 Column D and then look at each day after and tell me which day the price (Sheet2 Column C) is higher than the value in Sheet1 Column E.

    For example on Sheet1 Row 2: The formula would look at 8/14/2019 and then go to Sheet2 Column A to find that date. Then it would look at each day after and see when the price (Sheet 2 Column C) is greater than the price in Sheet1 Column E and then return the date. So in this example it would return 8/19/2019.

    Please let me know if I can clarify anything.

    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: Find the first value in a column that is greater and and return cell next to it

    You could try this ARRAY formula (entered by pressing Ctrl+Shift+Enter, instead of just Enter:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    - Moo

+ 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. Find the first value in a column that is greater and and return cell next to it
    By helpmeplea5e in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-03-2019, 01:01 AM
  2. Replies: 4
    Last Post: 12-09-2016, 12:54 PM
  3. Replies: 7
    Last Post: 12-06-2015, 05:40 PM
  4. [SOLVED] find value which is greater than in a range of cells and return the greater value
    By green369 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-11-2015, 02:46 AM
  5. [SOLVED] Find first value that is greater than X, and return value in another column
    By rabidchild in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-19-2014, 10:29 AM
  6. Replies: 6
    Last Post: 11-30-2012, 02:48 PM
  7. Associate/Find Nos and Return Equal/Greater
    By Celticshadow in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-16-2011, 07:24 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1