find lowest number?

Hi.

I have a problem i can't figure out a function that will find me a lowest number (look attached image) from C2 to F2 and return the dealers name in the first row to H2.
Does anyone have a clue how to achieve this or is it even possible?

I tried to paste =Index(C1:F1,Match(Min(C2:F2),C2:F2,0)) in to excel, but it complains that the function is wrong and is highlighting: =Index(C1:F1,Match(Min(C2:F2),C2:F2,0))

What's wrong?

That formula works for me but you may need ; instead of , for your version of excel, try

=Index(C1:F1;Match(Min(C2:F2);C2:F2;0))

Now it's working perfectly. Thanks to all who replied.