Hello, please please can someone help me: I have a simple forecasting sheet, where each month a payment is made, until the value reaches £0.
The example below, shows two lots of £500 per month - however if the payments were to increase or decrease this would change the month were £0 is achieved.
What I would like to know is which formula can I use to search for the cell that has £0.00, and return the month above into a cell somewhere else in the sheet.
I'm confused as to whether this is an INDEX formula or an HLOOKUP?
Thankyou
The example below, shows two lots of £500 per month - however if the payments were to increase or decrease this would change the month were £0 is achieved.
What I would like to know is which formula can I use to search for the cell that has £0.00, and return the month above into a cell somewhere else in the sheet.
I'm confused as to whether this is an INDEX formula or an HLOOKUP?
Thankyou
