How can the following be made (excel 97 SR -2):

in collumm A i have numbers (212021740, ...) i want to fill de collumms
B and C
acording to the first 3 numbers (212).
Collumms B and C must be automaticaly fill in agreement with some
rules
ex: 212XXXXXX Name1 code1
239XXXXXX Name2 code2
241XXXXXX Name3 code3
.... ... ...

Thanks :-)


+-------------------------------------------------------------------+
|Filename: Relat.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3795 |
+-------------------------------------------------------------------+

--
pmarques
------------------------------------------------------------------------
pmarques's Profile: http://www.excelforum.com/member.php...o&userid=25110
View this thread: http://www.excelforum.com/showthread...hreadid=466201