When I revert back to this old formula of "<" 0,
=INDEX(EBITDA_Forecasted!$B$5:$CG$5,MATCH(TRUE,EBITDA_Forecasted!$B7:$CG7<0,0))
It spits out the correct date.
When I change the sign and look at a different table, it does not work. I'm extremely baffled.![]()
Bookmarks