Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forumlas
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Forumlas or scripts? | Excel Discussion (Misc queries) | |||
how to transpose forumlas | Excel Worksheet Functions | |||
Circular Reference Forumlas | Excel Discussion (Misc queries) | |||
Forumlas Not Executing | Excel Discussion (Misc queries) | |||
Help with Commission forumlas | Excel Worksheet Functions |