INDEX-MATCH with MIN across multiple columns? #N/A help needed

[ADJuto]

It's best to start with sample data:

Type	Ripe_qty	Rotten_qty	Color
apple	6	3	red
apple	4		golden
banana	12	12	yellow
orange		31	orange
apricot	14	13	pink
apricot			brown
melon	9	1	green
strawberry			red
plum	7	10

<tbody>
</tbody>

The results should answer the question: "for each type of fruit, what is the color of the lowest quantity, regardless of ripe/rotten status?"
----meaning, I don't really care whether the # is associated with Ripe or Rotten; I just need to know the color of the lowest number
----cells which are blank are truly blank. no values exist, but when encountered, some default value is set like '20'

Expected Results Table

Type	Color (formula needed here)	'manual answer' + notes
apple	red	3 is the minimum value, and that matches red. the blank cell in the golden row is either ignored or replaced with the default value of 20
banana	yellow	12
orange	orange	31 is the minimum value. Replacement of the empty cell with the default value of '20' would yield an incorrect answer based on the arbitrary value. Take the actual values when one is present.
apricot	pink	13
melon	green	1
strawberry	red	absent any values in either column.
plum	{formula}?	7 and the answer provided by the formula will be 'zzNoColor'

<tbody>
</tbody>

Any ideas or strategies?

 

[Eric W]

Maybe:

	A	B	C	D	E	F	G	H
1	Type	Ripe_qty	Rotten_qty	Color		Type	Color
2	apple	6	3	red		apple	red
3	apple	4		golden		banana	yellow
4	banana	12	12	yellow		orange	orange
5	orange		31	orange		apricot	pink
6	apricot	14	13	pink		melon	green
7	apricot			brown		strawberry	red
8	melon	9	1	green		plum
9	strawberry			red
10	plum	7	10

<tbody>
</tbody>

Sheet11​

Worksheet Formulas Cell Formula G2 =LOOKUP(2,1/(($A$2:$A$10=F2)*(($B$2:$B$10=MAX($B$2:$C$10*($A$2:$A$10=F2)))+($C$2:$C$10=MAX($B$2:$C$10*($A$2:$A$10=F2))))),$D$2:$D$10)&"" <tbody> </tbody>

<tbody>
</tbody>

 

[Eric W]

A somewhat shorter version of the formula:

=LOOKUP(2,1/(($A$2:$A$10=F2)*MMULT(--($B$2:$C$10=MAX($B$2:$C$10*($A$2:$A$10=F2))),{1;1})),$D$2:$D$10)&""