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! |
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! |
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! |
All times are GMT +1. The time now is 07:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com