Lookup low value and return name in row above

[Milo_D]

I am looking for a formula that would compare values in three non-contiguous cells (all in same row), and return the value (or values) in the Row 1 cell that corresponds with the minimum value(s) of those cells. In sample table below, looking for formula for cells G2 through G5.

In sample below, the formula for cell G2, finding the minimum of A2, C2 and E2, and returning the text in Row 1 above..
And for cell G3, returning the values for the two (tied) minimum cells of A3, C3 and E3?

	A	B	C	D	E	F	G
1	Bidder Smith		Bidder Jones		Bidder Roberts		Low Bidder
2	20	Other data	30	Other data	40	Other data	Bidder Smith
3	20	Other data	20	Other data	30	Other data	Bidder Smith, Bidder Jones
4	30	Other data	15	Other data	30	Other data	Bidder Jones
5	50	Other data	50	Other data	45	Other data	Bidder Roberts

<tbody>
</tbody>

Any expertise much appreciated.....

 

[Aladin Akyurek]

In G2 control+shift+enter, not just enter, and copy down:

=TEXTJOIN(",",TRUE,IF(A2:F2=MIN(IF(MOD(COLUMN(A2:F2)-COLUMN(A2),2)=0,A2:F2)),$A$1:$F$1,""))

Hope your system has the TEXTJOIN function.