Apr 25 2022 06:50 AM
I have a list (show below) to compare the "paid Over" field with the running total. It returns a false unless the value is more. I want to then get the "9 Months ( or whatever # of months returns true in the list) to show in the "break Even cell" above so i can use the break even point in a graphic. What formula do I use to search through a list and give me the value when "not false"
Apr 25 2022 07:35 AM
I've attached a sample file that uses INDEX and MATCH to produce the result. I didn't recreate your entire page, which didn't seem necessary. You can change either of the numbers with a yellow background to test the function.
This is the formula that is in cell B4 of the attached spreadsheet; an image of it is here.