How to find the closest colour within in given RGB-range

[caymane]

Hi

I would like to find the closest NCS-colour (column D) with matches the exact values given in I2:K2. If there isn't any colour with the correct RGB-values I'd like to find the closest given the max. deviation in H3. This would give me ranges for each colour channel.

I have no clue where to start with. Any help is highly appreciated.

BR

 

[StephenCrump]

Welcome to the Forum!

Exact match: =FILTER(D2:D30,MMULT(--(A2:C30=I2:K2),{1;1;1})=3)
Within +/-2: =FILTER(D2:D30,MMULT(--(ABS(A2:C30-I2:K2)<=H3),{1;1;1})=3)

 

[caymane]

Welcome to the Forum!

Exact match: =FILTER(D2:D30,MMULT(--(A2:C30=I2:K2),{1;1;1})=3)
Within +/-2: =FILTER(D2:D30,MMULT(--(ABS(A2:C30-I2:K2)<=H3),{1;1;1})=3)

Thanks

what if I wanted to find the closest value at all? No deviation given.
MIN....something. I don't know how to combine this with the MMULT(--....

BR

 

[StephenCrump]

Try: =FILTER(D2:D30,MMULT(--(ABS(A2:C30-I2:K2)),{1;1;1})=MIN(MMULT(--(ABS(A2:C30-I2:K2)),{1;1;1})))

 

[caymane]

cheers mate!

Added a TRANSPOSE to it and that did the job to remove #SPILL-errors! Have to do some checking if the results are correct.