Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lists 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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lists urgent help needed
Take a look at VLOOKUP in Help.
In article , mark stillman wrote: 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lists urgent help needed
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 "mark stillman" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent Help Needed please | Excel Worksheet Functions | |||
Help Needed Urgent | Excel Discussion (Misc queries) | |||
Urgent Help needed | Excel Discussion (Misc queries) | |||
Urgent help needed | Excel Worksheet Functions | |||
Urgent help needed! | Excel Worksheet Functions |