Hi, try

=IF(MIN(B6:D6)=B6,$B$5,IF(MIN(B6:D6)=C6,$C$5,$D$5) )

I assume that your names are in row 5

"TJC" wrote:

Thanks, I tried this, but am actually looking to have the Best Price column
reflect the vendor name rather than the "best price". Thanks again for your
help!

"Eduardo" wrote:

Hi,

=MIN(B6:D6)

change range to fit your needs

if this helps please click yes thanks

"TJC" wrote:

Acme XXX Price OOO Price Best Price
$46.21 $49.95 $56.21 Acme

I am looking to create a formula that will compare the three prices listed
and enter the lowest price header into the "best price" column.