Sample data sheet: https://docs.google.com/spreadsheets/d/1EIQcpzwdaoNSKEPu-F1NCUOtEjS6Ez0P73dmotClT7Q/edit?usp=sharing
The ultimate goal is to have a
Month + year show in a single cell, according to the first instance of "New total" being> = 0.
The sheet includes sample data and the format with which we are interacting.
In the purple box, I want the month + year to be completed, based on the fact that the first instance of "New total" is> = 0. When the formula reaches the first instance of> = 0 (March in the sample data ), I want it to then extract "March" from cell Q2 and concatenate with "2019" from cell "S2". The values of "New total" are dynamic and will change periodically. At this time, the sample data should result in "March 2019", but tomorrow it could change so that "February" is the first instance> = 0.
Input: Row of numbers, looking for the first instance of "New total" being> = 0.
Output: Extract month + year once "New total" has found int> = 0 in the specified row. Show in the specified cell.
This is how it was done with nested IF statements:
= IF (G15> = 0, E14 & "" & G14, IF (J15> = 0, H14 & "" & J14, IF (M15> = 0, K14 & "" & M14,