Hi

=CHOOSE(MATCH(A1,{-99999;1;4;7;10},1),"","left","midle","right","")


--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )



"Erik B" wrote in
message ...

Yes I know that, but i mean something else
Example:
1 to 3 Excel has to say left
3 to 6 Excel has to say middle
6 to 9 Excel has to say right
And when I change a value the name has to change too.


--
Erik B
------------------------------------------------------------------------
Erik B's Profile:
http://www.excelforum.com/member.php...o&userid=27621
View this thread: http://www.excelforum.com/showthread...hreadid=471681