Not real sure what you're wanting but here's one way to get the column
header:

Year1...Year2...Year3
...50.........27........99

="Year"&MATCH(MIN(B38:D38),B38:D38,0)

If your column headers aren't really named "Year_n":

=INDEX(B32:D32,MATCH(MIN(B38:D38),B38:D38,0))

I have to embed that function within the LOOKUP function

The LOOKUP function *requires* the lookup_vector be sorted in ascending
order. If it's not sorted it won't work properly.

--
Biff
Microsoft Excel MVP


"Brian204845" wrote in message
...
OK here's the problem. Asignment in school due tomorrow. I have to use
the
MIN function to find the lowest expense in a row of three cells (B38 C38
and
D38). No problem thee =MIN(B38:D38). But I have to embed that function
within the LOOKUP function in order to find the matching column label
(Year 1
Year 2 and Year 3) which are in cells B32 C32 and D32. I have to print
"minimum expense year" under the the appropriate cell with the lowest
expense. The cells immediately below the three cells with the expense
numbers are B39 C39 and D39. I can't seem to get this right. Any
suggestions would be appreciated! Brian