worksheet 1 is set up as follows
column A has a 5 digits stock numbers
column B has the description of that stock number
column C has the price of that stock number

when I am in work sheet 2 I want to input a stock number in cell A1 and need
a formula in Cell B1 so it will find the description of the stock number
from work sheet 1, then the same for cell C1 but find the price. I have to
work with about 200 different stock number.
(if there is a differnt option other then a formula to have the description
and price to be found and inputted i am all ears)

Thanks to all who help