How to compare values in Excel?

I have a table of product prices and need to find out which is the lowest price.However how can i get it to compare row by row and return the value and company name to another cell? I got stuck and the “IF” function.
Can anyone advise. Thank very much.

table1

Hi

Have you seen this thread? Maybe it helps:

1 Like