Can someone help me in creating a function to look up the following data:

Table:

Year 1 2 3 4 5 6
2,002 -137.15 -232.68 420.57 529.72 862.24 -103.23
2,003 985.12 985.05 999.49 982.1 1195.98 1005.19
2,004 274.52 547.62 468.69 442.84 337.74 561.39
2,005 474.75 502.9 516.04 445.04 103.68 870.25
2,006 574.68 506.82 506.59 502.93 57.6 213.25

I am trying to look up the min value per year and return the corresponding
number for that column. Example, I want the min value in 2002, to return (2)
because that is the period in which it fell. Then be able to do the same for
each year (min and max values, return the Period (#) which they fell.