Forumlas
Use VLOOKUP:
Use Data Validation (DV ) to select your stock numbers.
Assuming your Stock table iis in Sheet2 columns A to C:
If stock number (DV) is in A2:
in B2: =VLOOKUP(A2,Sheet2!A:C,2,0)
to get Quantity
in C2: =VLOOKUP(A2,Sheet2!A:C,3,0)
to get Description
HTH
"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!
|