finding the cell with min value and returning the contents of neig

[Guest]

I have a worksheet that contains detect levels for various compounds. In the
range AD7:AD46 are the Minimun detectable levels of the compound. at the
botom of the Col in cell AB49 I need a formula that will return the contents
of the cell that is found two cells to the left (within Col AB) of the
Minimun value within the range AD7:AD46.
(Note Column AC is hidden and currenlty not used)

If I need to send an example let me know...

I just dont know how to return, within a formula, the cell number where the
min value is located.

I would assume the formula would look something like this within cell AB49:

=Value of cell(2 cells to the left of the Min(AD7:AD46))

 

[T. Valko]

Try this:

=INDEX(AB7:AB46,MATCH(MIN(AD7:AD46),AD7:AD46,0))

Biff