Find Lowest Value from row and match value with header name

**Kevin Rush** · 02-24-2022, 03:14 PM

Hi all,

I have a table with list of items in the right column and a list of vendors in the top row I then have a price for each item from each vendor. In the last column I want the name of the cheapest vendor. If possible more than one vendor has the same price I would like both of them to appear in the last column (although this isn't as important).

Thanks

**Richard Buttrey** · 02-24-2022, 03:22 PM

Hi,

This will return the lowest and the next lowest.

=INDEX($C$5:$F$5,1,MATCH(SMALL(C6:F6,1),C6:F6,FALSE))&" - "&INDEX($C$5:$F$5,1,MATCH(SMALL(C6:F6,2),C6:F6,FALSE))

**Kevin Rush** · 02-24-2022, 03:33 PM

Thanks! I was trying Hlookup and all sorts!

**Bo_Ry** · 02-24-2022, 03:45 PM

Please try

=TEXTJOIN(", ",,FILTER($C$5:$F$5,C6:F6=MIN(C6:F6)))

**Kevin Rush** · 02-24-2022, 03:47 PM

Wow!! that is brilliant. Thank you so much!!!

**wk9128** · 02-25-2022, 05:38 AM

Cell G6 formula , Drag down

Formula:

Please Login or Register  to view this content.

Find Lowest Value from row and match value with header name

LinkBack

Thread Tools

Rate This Thread

Display

Find Lowest Value from row and match value with header name

Re: Find Lowest Value from row and match value with header name

Re: Find Lowest Value from row and match value with header name

Re: Find Lowest Value from row and match value with header name

Re: Find Lowest Value from row and match value with header name

Re: Find Lowest Value from row and match value with header name

Thread Information

Users Browsing this Thread

Similar Threads

Find lowest in 2 or more columns within each row of sheet, sum the total of all the lowest

[SOLVED] Find First Match in Range Return Header Value

[SOLVED] Find Match or Next Lowest Number In Descending Column of Numbers

Using Index / Match / Mini to find three lowest values in a row.

[SOLVED] Need help - Match number in column, find lowest number in that row, and return header name

[SOLVED] Find lowest score and match to person from list

Find Lowest Time, Match with Column Heading

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions