Need help with INDEX/MATCH with three columns

[Margooox]

Hello everyone!

It's my first time posting here and I,m an Excel newbie and am learning on my own, so please bear with me!

I have a database of colors with their names and RGB values spread throughout three columns.

I also have a system in a different tab that mixes colors together and outputs new RGB values.

Now, using the INDEX/MATCH formulas, I want to take my custom RGB values and find the name of the closest match from my database by comparing the RGB values.

I have found this formula online which would do exactly what I need. I've tried using it but it returns an error and I'm not quite sure how to work with it.

Here's the formula that I have which doesn't work:

Are there better formulas to do this? How would you go about this?

Thank you in advance to anyone who will try to help me!

 

[Eric W]

Welcome to the MrExcel forum!

Maybe:

Book1
	C	D	E	F	G	H	I	J
1	Name		Hex	Red	Green	Blue		Pastel Red
2	Snow		#FFFAFA	255	250	250
3	Baby Pink		#F4C2C2	244	194	194
4	Pastel Red		#FF6961	255	105	97
5	Indian Red		#FF5C5C	255	92	92
ColorListNew

Cell Formulas
Range	Formula
J1	J1	=INDEX(SORT(CHOOSE({1,2},ColorListNew!C2:C10,(ColorListNew!F2:F10-ColorProfile!G4)^2+(ColorListNew!G2:G10-ColorProfile!H4)^2+(ColorListNew!G2:G10-ColorProfile!I4)^2),2,1),1,1)

 

[Eric W]

Here's a more succinct way to write that formula:

=INDEX(SORT(CHOOSE({1,2},ColorListNew!C2:C10,MMULT((ColorListNew!F2:H10-ColorProfile!G4:I4)^2,{1;1;1})),2,1),1,1)

 

[Margooox]

Thank you so much, it works perfectly!!

 

[Eric W]

Happy to help! Thanks for the feedback. ?

(And just for my own amusement, a still shorter way:

=INDEX(SORTBY(ColorListNew!C2:C10,MMULT((ColorListNew!F2:H10-ColorProfile!G4:I4)^2,{1;1;1})),1)