is this possible

[Bob Bob]

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

 

[T. Valko]

Try these:

B1:

=VLOOKUP(A1,Sheet1!A:C,2,0)

C1:

=VLOOKUP(A1,Sheet1!A:C,3,0)

 

[Bob Bob]

thanks worked perfectly

Try these:

B1:

=VLOOKUP(A1,Sheet1!A:C,2,0)

C1:

=VLOOKUP(A1,Sheet1!A:C,3,0)

 

[T. Valko]

You're welcome. Thanks for the feedback!