I need to look up a value that is to the left of the source column. Eg. my work sheet is setup as follows:

Name Jan Feb Mar
----- --- --- ----
Tim 10 12 13
Pam 15 9 17
Amy 8 11 15

The minimum value of Jan. = 8, Feb. = 9 and Mar. = 13.

Now based on the minimum of lets say Jan (8), i would like to display the name of Amy since she has the lowest score.

A vlookup doesn't allow you to look for columns that come before vlookup_value.

How can i go around this?