Start point

Hi All

I need help with a formula.

I have a sheet, Columns (Periods) and Sales. I have a input field at the end of the columns, where I want to be able to enter a figure and it brings back the min sales point (period).

So for example if I enter 425 in the input field, the cell next to it will bring back the period number above it. However this is going to be fairly average.

Not sure if it's possible at all. I I have attached an example sheet for you too look at.

Thanks

Column Header Retrieval.xlsx

I used this formula all the time, I can't believe I didn't see the solution!!

Thanks for your help