If the stock code contains preceding 0's ,it is better to convert Sheet1 Column B into TEXT format.
Select the required range ,Right click ,Format cells
In Number Tab select Text and OK.