On Jan 21, 2:09 pm, "T. Valko" wrote:
Try this:

=INDEX(I2:R2,MATCH(MIN(I2:R2),I2:R2,0)-1)

Note that if there is more than one instance of the lowest price the
formula
will return the vendor corresponding to the 1st instance of the lowest
price
from left to right.

--
Biff
Microsoft Excel MVP


You are totally freakin' awesome! That worked perfectly! Exactly
what I was looking for. :)

Thanks again,
Veronica


You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP