I am using the following two formulas in Excel 2007
=MIN($J$2:$M$2)
=INDEX($J$1:$M$1,MATCH(Q2,J2:M2,0))
I need to make the second formula apply to the rest of the cells in Column P but it when I try to paste it for the other cells I don't get the desired result.
Basically I am trying to find the lowest value across a row of cells and then identify it by the header on that column. It is a least cost project for 4 suppliers. Its over 1400 rows of data.
Thanks in advance for any help!
Bookmarks