Show cell value based on list selection
 

I have a worksheet I created that has 2 columns column 1 has various company
names and column 2 has a generated number I formated using (Left(b2,4)&"01").
Now what I want to be able to do is when I select one of the company names
from a list on another worksheet created using the validate data tool I want
the contents of the cell to show the the colmn 2 value not the column 1
value. I am new to programming Excel.

I am using Office Excel 2003 (11.8146.8132) SP2