I want to find the cell with the minimal value in the range(m25:m39), and then get row number of the cell, and at last get the value at column 'D' with the same row of the cell with the minimal value.
=CELL("contents","D" & TEXT(MATCH(MIN(M25:M39),M25:M39,0),"0"))
but the statement above is wrong how to fix it?
Bookmarks