Lookup question

[yuryyuryyury]

I have data like this:

Q - D - E - R - T - MIN
4 - 1 - 2 - 3 - 7 - 1
3 - _ - 5 - _ - _ - 3
3 - 2 - 2 - 4 - _ - 2

Headings in row 1, data in rows 2 on down. The underscores are blank cells.
In column F, I have a formula calculating the MIN of A:E. instead of returning the MIN value, is there a way I can get it to return the column heading?

There are cases where there will be two MIN values in the same row. I bold the correct one manually for each row, so maybe there's a way to check a cell's formatting and return the column heading?

[daddylonglegs]

Try this formula in F2 copied down

=INDEX(A$1:E$1,MATCH(MIN(A2:E2),A2:E2,0))

Where there are two equal MIN values in a row this will return the header associated with the leftmost

[yuryyuryyury]

thanks! that does work!

Is there a way to return the heading if a cell in the range is bold rather than the MIN of the range?

[VBA Noob]

yuryyuryyury,

Thread closed for cross posting. Please read forum rules below. If you agree to them then PM me

VBA Noob