I need to create a formula to do the following: -

Column A - has stock numbers
Column B - Quantity
Column C - Description

How do I do a formula that will automatically put in the description once I
enter the stock number?

I have another sheet in the same workbook with all of the stock numbers and
descriptions to work from.

Thanks!