+ Reply to Thread
Results 1 to 4 of 4

How to create a formula to return a cell to the right of the result of another formula

  1. 07-05-2017, 02:12 PM #1
    Daniel777
    Daniel777 is offline
    Registered User
    Join Date
    07-05-2017
    Location
    Ontario
    MS-Off Ver
    2010
    Posts
    13

    How to create a formula to return a cell to the right of the result of another formula

    Basically, I have this formula in a cell to return the very first non 0 value in a row:

    =INDEX('Financials Cashflow Year'!C30:M30,MATCH(TRUE,INDEX('Financials Cashflow Year'!C30:M30<>0,),0))

    I would like a formula to return the value of the cell on the right of the one picked up by this very first formula.

    Say we have sheet 1 first row: 0 0 0 4 3 2

    Sheet 2 I would like to see with the formulas. 4 3 2

    Something that can be scaled to other rows and columns of course.

    Another example:

    Sheet1
    Year 2016 2017 2018 2019
    Spend 0 0 2 1

    Sheet2 with the formula
    Year 2018 2019
    Spend 2 1
    Reply With QuoteRegister To Reply
  2. 07-05-2017, 02:28 PM #2
    sourabhg98
    sourabhg98 is offline
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: How to create a formula to return a cell to the right of the result of another formula

    Use this formula to get the first non 0 value (spend 2) in your example-
    Please Login or Register  to view this content.
    Now you can copy and paste the cell containing this formula upwards, downwards or on the right to get adjacent values from Sheet1
    Happy to Help

    How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html

    "I don't get things easily, so please be precise and elaborate"

    If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
    If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.

    Sourabh
    Reply With QuoteRegister To Reply
  3. 07-05-2017, 04:23 PM #3
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: How to create a formula to return a cell to the right of the result of another formula

    Daniel777 welcome to the forum.

    I'm not entirely sure I understand the data setup, but see if this can be adapted to suit your needs.

    In L1 and filled down.
    Formula: copy to clipboard 
    Please Login or Register  to view this content.



    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
    1
    0
    0
    0
    0
    8
    2
    3
    6
    4
    9
    7
    8236497
    2
    0
    0
    0
    0
    0
    0
    0
    6
    5
    7
    7
    6577
    3
    0
    0
    0
    0
    8
    4
    84
    4
    0
    0
    0
    0
    7
    7
    4
    4
    7744
    5
    0
    0
    0
    0
    0
    0
    0
    9
    6
    7
    3
    9673
    6
    0
    0
    3
    7
    0
    370
    Dave
    Reply With QuoteRegister To Reply
  4. 07-05-2017, 04:48 PM #4
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: How to create a formula to return a cell to the right of the result of another formula

    Of course you could also use tigeravatar's Concatall UDF.
    http://www.excelforum.com/tips-and-t...ml#post3096647

    Please Login or Register  to view this content.
    Then the formula in M1 of the attached would be
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Return Cell Address of the min() formula result
    By ciprian in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-20-2013, 08:47 AM
  2. Excel Formula Return Result to Same Cell
    By heygoogoo in forum Excel General
    Replies: 10
    Last Post: 02-24-2010, 04:40 PM
  3. Formula Return result from non empty cell
    By innocent_eyes in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-22-2008, 03:23 AM
  4. How to return the result of a cell's formula as an argument within a running macro?
    By Worldman1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-26-2006, 02:10 AM
  5. Advanced formula - Return result & Show Cell Reference of result
    By Irv in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-05-2006, 10:40 PM
  6. My formulas return the formula not a result in the cell
    By 1stcoast in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-22-2006, 09:50 PM
  7. [SOLVED] Enter a formula to return a result from a cell
    By LMB in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 12-03-2005, 10: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1