Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting data from a product matrix
Hello everyone,
I have a product matrix with the product names in cells A4:A37. The list of equipment that the product requires is my column headers at B3:AE3. In a seperate sheet, I want to be able to use a drop down list and select a desired product. Once the product is selected, the next cell will reference this cell and display all the equipment needed in the column headers. (I can get it to display 1 column header but not all). Can anyone help or do I need to elaborate more? example Room 1 Room 2 Room 3 Room 4 product a X X product b X X X product c X product d X X X X I want the second sheet to display Room 1 Room 3 when I choose Product a from the drop down list. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manipulating a matrix of data | Excel Discussion (Misc queries) | |||
Plot data from column to matrix | Excel Discussion (Misc queries) | |||
Formula for Extracting Alphabetic Part of a Product Code | Excel Worksheet Functions | |||
Formula for Extracting Alphabetic Part of a Product Code | Excel Worksheet Functions | |||
Formula for Extracting Alphabetic Part of a Product Code | Excel Worksheet Functions |