+ Reply to Thread
Results 1 to 4 of 4

Formula To Return A Result Based On A Set Of Criteria

  1. #1
    Registered User
    Join Date
    05-29-2011
    Location
    London
    MS-Off Ver
    Excel 365
    Posts
    20

    Formula To Return A Result Based On A Set Of Criteria

    I have an excel spreadsheet which has months of a year in a row increasing by one month in each respective cell. Under the row of dates are a row of numbers (Cash Flow for a project). The cells under each date start with negative amounts and then over a time turn positive.
    Under this row there is another row which adds the above cells to give a running number.

    In an unrelated cell I then ran a formula to work out the cumulative most negative number. I used a Min formula. What I am now looking to do is run another formula to work out which date was the lowest period in the calculation. I have tried a HLOOkUP but it never worked.

    I have attached a spreadsheet would be grateful if you could asssit.

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Formula To Return A Result Based On A Set Of Criteria

    Try:

    =INDEX($G$2:$IL$2,MATCH(E12,$G$10:$IL$10,0))

    Format the result as Date.
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,209

    Re: Formula To Return A Result Based On A Set Of Criteria

    Hi,

    This formula should do you.

    =INDEX(G2:IL2,MATCH(E12,G10:IL10,0))

    Index Match on a row.xlsx
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Registered User
    Join Date
    05-29-2011
    Location
    London
    MS-Off Ver
    Excel 365
    Posts
    20

    Re: Formula To Return A Result Based On A Set Of Criteria

    Thanks worked perfectly.

+ 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. Return the earliest result and latest result with criteria
    By PFDave in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 04-26-2016, 07:20 AM
  2. Replies: 3
    Last Post: 02-09-2016, 05:08 AM
  3. [SOLVED] Return result based on multiple criteria..
    By Frazzfreeman in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-02-2014, 03:47 AM
  4. Replies: 7
    Last Post: 09-06-2013, 11:59 PM
  5. Need help with a date comparison formula - Return text based on result
    By kcleere in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-16-2013, 03:58 PM
  6. [SOLVED] Lookup formula required to search for two criteria and return result
    By dave1983 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-12-2012, 03:29 PM
  7. Return Result based on Multiple Criteria
    By franciz in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-20-2009, 01:30 PM

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