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

Try these formulas in cells B5 and C5 respectively:-

=VLOOKUP(VALUE(LEFT(A5,3)),$E$5:$G$7,2,FALSE)
=VLOOKUP(VALUE(LEFT(A5,3)),$E$5:$G$7,3,FALSE)

Copy them down to cells B6:B474 and C6:C474

Note you will get #N/A's where the code doesn't exist in the Example
table E5:G7


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