+ Reply to Thread
Results 1 to 4 of 4

Return the text in one cell of a row based on a criterion for a corresponding row

  1. #1
    Registered User
    Join Date
    11-05-2020
    Location
    Denver, Colorado
    MS-Off Ver
    365
    Posts
    3

    Return the text in one cell of a row based on a criterion for a corresponding row

    That title makes it sound really confusing, but it's quite a simple question I just can't see to figure it out (slightly embarrassed about this). I want to return the month that the salary will start in this array:

    January February March
    Salary - 1,000 1,000

    What would be the formula that returns the text "February"?

  2. #2
    Registered User
    Join Date
    11-05-2020
    Location
    Denver, Colorado
    MS-Off Ver
    365
    Posts
    3

    Re: Return the text in one cell of a row based on a criterion for a corresponding row

    The table looks strange. For clarity, in January the salary is 0. Then it is 1,000 in February and March.
    Last edited by dpurinton; 11-05-2020 at 08:05 PM.

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,463

    Re: Return the text in one cell of a row based on a criterion for a corresponding row

    With month in B1:D1
    Salary in B2:D2

    Returns first month with salary>0 from left:

    =INDEX($B$1:$D$1,MATCH(TRUE,B2:D2>0,0)
    Quang PT

  4. #4
    Registered User
    Join Date
    11-05-2020
    Location
    Denver, Colorado
    MS-Off Ver
    365
    Posts
    3

    Re: Return the text in one cell of a row based on a criterion for a corresponding row

    Thank you!

+ 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. [SOLVED] Search and Return based on Text with another cell
    By pmw19800 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-29-2020, 09:20 PM
  2. Replies: 1
    Last Post: 04-04-2019, 11:35 PM
  3. Replies: 3
    Last Post: 12-03-2014, 05:43 PM
  4. Find value based on item number (first criterion) and date (second criterion)
    By ivan.stajin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-19-2014, 10:47 AM
  5. Trying to Return a Number in a Cell based on Text
    By jslavinsky in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-01-2014, 03:17 PM
  6. VLOOKUP return value based on text in cell
    By Detrie in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-04-2014, 07:17 PM
  7. [SOLVED] Can't Get Excel To return data based on 2 criterion from Pivot Table
    By thecuteonexoxo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-27-2012, 01:35 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