Results 1 to 2 of 2

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

Threaded View

helpmeplea5e Find the first value in a... 10-12-2019, 11:14 AM
Moo the Dog Re: Find the first value in a... 10-12-2019, 12:50 PM
  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

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