 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / June 2007lists urgent help needed
Hi, im trying to set up a spread sheet for the tand c dept where i work and we need a list that when an item is selected from it the cells next to it should automatically show the part number and the weight of the units, any ideas? Take a look at VLOOKUP in Help. > Hi, im trying to set up a spread sheet for the tand c dept where i work and > we need a list that when an item is selected from it the cells next to it > should automatically show the part number and the weight of the units, any > ideas? Mark, Look at "Data Validation" to generate your list and use VLOOKUP to get the other data. Create a table with item, part number and weight: let's say this table is columns A to C of Sheet2 in rows 2 to 100. In Sheet1 , cell A2 create your Data Validation: Data=>Validation=>List=>Source: =Sheet2!A2:A100 (include "=") in B2: =VLOOKUP(A2,Sheet2!$A$2:$C$100,2,0) .... get Product number in C2: =VLOOKUP(A2,Sheet2!$A$2:$C$100,3,0) .. get weight HTH > Hi, im trying to set up a spread sheet for the tand c dept where i work and > we need a list that when an item is selected from it the cells next to it > should automatically show the part number and the weight of the units, any > ideas? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.