Please help me regarding extracting results from 3 nearest value /criteria

[xtian1990]

Good day! Here's my problem, that i can't really find the solution.

I have a table simmlar to this,

Color name	R	G	B
Cream	252	255	217
Magenta	222	0	237
Pink	255	92	217
Lilac	151	116	204

<tbody>
</tbody>

I have 150 of these colors.

I'm planning to make 3 inputs as my lookup value, and look for this table to match the nearest RGB value and give me the color name as the result.

I can make it with index and match, but with exact RGB values only, but I need the nearest RGB values. Please help me.

 

[Comfy]

Does this work?

Excel 2010
	A	B	C	D
1	Color name	R	G	B
2	Cream	252	255	217
3	Magenta	222	0	237
4	Pink	255	92	217
5	Lilac	151	116	204
6
7
8
9	Required
10	R	200
11	G	50
12	B	150
13
14	Suggested Color	Magenta
15	R	222
16	G	0
17	B	237
Sheet1

Cell Formulas
Range	Formula
B15	=INDEX($B$2:$D$5,MATCH($B$14,$A$2:$A$5,0),MATCH($A15,$B$1:$D$1,0))
B16	=INDEX($B$2:$D$5,MATCH($B$14,$A$2:$A$5,0),MATCH($A16,$B$1:$D$1,0))
B17	=INDEX($B$2:$D$5,MATCH($B$14,$A$2:$A$5,0),MATCH($A17,$B$1:$D$1,0))
B14	{=INDEX(A2:A5,MATCH(MIN(ABS(B2:B5-B10)+ABS(C2:C5-B11)+ABS(D2:D5-B12)),ABS(B2:B5-B10)+ABS(C2:C5-B11)+ABS(D2:D5-B12),0))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[xtian1990]

WOW! it did worked! Thank you very much! You saved my life :D

 

[Comfy]

Well it will work but!!!

Is the method for returning the closest match correct?

The formula subtracts the required RGB from each of the listed RGBs and sums the difference.

It then returns the colour whos total sum is the smallest.

 

[xtian1990]

I did that before by creating helping columns, subtracting then getting smallest sums, but did not showed good results. But your formula seems better, im trying many color now and worked fine, really close results. Maybe i did something wrong on my first method. Thank you very much