Forumlas
You would use Vlookup in the description column
=VLOOKUP(A2,Sheet2!$A$1:$B$50,2,FALSE)
Drag down as far as rtequired
Where A2 is the stocknumber you are entering and Sheet 2 A1 to B50 are the 2
columns with stock No#s abd descriotions in.
Mike
"Lisa" wrote:
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!
|