# How to list the cheapest supplier for certain products

1. ## How to list the cheapest supplier for certain products

Hello guys,
Book1.xlsx
I'd like to ask you for assistance. I have attachet spreadsheet of
different products in rows
different suppliers offering these products
values are the prices

can some body help me and show me how to make an formula with will be standing in last column and will show the cheapest supplier's name (see atthacment)

Thank you very mnuch in advance,

Tjas

2. ## Re: How to list the cheapest supplier for certain products

=INDEX(\$B\$1:\$G\$1,MATCH(MIN(B2:G2),B2:G2,0)) this will give the first supplier who is cheapest

3. ## Re: How to list the cheapest supplier for certain products

thank you mr martin!

4. ## Re: How to list the cheapest supplier for certain products

Just a little more request. Id like also to colour each row's lowest value by conditional formatting.

The best I came up to is to color the lowest value in one row by formula =B2=MIN(\$B\$2:\$G\$2)

( I have 1000 rows to colour is there some other easier option!?)

attachment:
Book1 coloured.xlsx

5. ## Re: How to list the cheapest supplier for certain products

change the referencing to
=B2=MIN(\$B2:\$G2)
apply to b2 then copy the format to all the other cells

6. ## Re: How to list the cheapest supplier for certain products

copy one cell then paste special format only for all the rows.

7. ## Re: How to list the cheapest supplier for certain products

it worked with copy/paste.

thank you!

8. ## Re: How to list the cheapest supplier for certain products

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as "SOLVED".
For the meantime I'll do it for you.

How?
New quick method:

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Note:
You can also thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given.
By doing so you can add to the reputation(s) of those who helped and shared their time in helping you.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1