Hi

Does anyone know of a formula that will display the cell reference of a
given value? Basically I have a schedule running across 4 years (Columns) and
demands for various parts. I have total requirement and stock level calls:
I'd like to be able to say "Find the cell where the Sum of a.....x column is
greater than the stock level"- i.e. when do will we run out. I know I could
use a subtotal for each date but that would mean an extra column and I would
prefer to keep it as automated as possible

Many Thanks