Hi there
I'm having difficulty finding a formula that will lookup along a row and at the point the value goes below 0 (or a defined number) returns the column header. e.g....
jan10 feb10 mar10 apr10
Widgets 15 10 3 -2
Cans 4 2 -1 -5
Pulls 10 0 -7 -13
So for widgets it would return Apr10 etc
I've tried vearious forms of Index/Match but to no avail and it's driving me crazy - is anyone able to help?
Thanks
Ellieg79![]()
Bookmarks