If the number of possibilities is the same for
each color (here 4 e.g. {1,3,5,7}), here's another
option:

=INDEX({"BLUE","YELLOW","GREEN","RED","PINK","BLAC K","BROWN"},
ROUNDUP(MATCH(x,{2,4,6,8,1,3,5,7,10,12,14,16,11,13 ,15,17,100,200,300,
400,500,600,700,800,45,55,65,75},0)/4,0))

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"Mgt" skrev i en meddelelse
...
thanks--this was the most helpful by far!
But I am still encountering problems after about 7 groups (are these
called
arrays?)
Anyway I tried to do this and got a Value error:
=IF(OR(x={2,4,6,8}),"BLUE",IF(OR(x={1,3,5,7}),"YEL LOW",IF

(OR(x={10,12,14,16}),"GREEN",IF(OR(x={11,13,15,17} ),"RED",IF(OR(x={100,200,3
00,400}),"PINK",IF(OR(x={500,600,700,800}),"black" ))))))=IF(OR(x={45,55,65,7
5}),"BROWN...etc...i.e. group 3 groups of seven parenths, but not
working...