Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I make other cells dependent on my drop down list?
I'd like to have other cells in the row of the drop down list change according to what I've chosen in the list. Is a drop down list the best method for this application? I have a table of material properties that I would like to read from based on what material is chosen from the drop down list. -- mae1778 ------------------------------------------------------------------------ mae1778's Profile: http://www.excelforum.com/member.php...o&userid=25716 View this thread: http://www.excelforum.com/showthread...hreadid=391295 |
#2
|
|||
|
|||
Hi Mae
Sounds like you need a VLOOKUP formula in the cells that you want to changesd, based on the item you've chosen in the drop-down list. Assuming you have a table of material properties then the formula will need to know: 1, The cell containing the chosen material (the one with the drop-down) 2, The location and extents of the properties table 3, The column number contaning the property you want looking up 4, The switch FALSE in order to prevent problems if the properties table is sorted by some other column in future. In summary, the formula would look something like this: =VLOOKUP(A1,Properties table,2,FALSE) Where the material you want to look up is in column 1 of the properties table and the proprty is in column 2 Hope this helps Phil mae1778 wrote: I'd like to have other cells in the row of the drop down list change according to what I've chosen in the list. Is a drop down list the best method for this application? I have a table of material properties that I would like to read from based on what material is chosen from the drop down list. -- mae1778 ------------------------------------------------------------------------ mae1778's Profile: http://www.excelforum.com/member.php...o&userid=25716 View this thread: http://www.excelforum.com/showthread...hreadid=391295 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy drop down boxes and associate to cells dynamically in excel | Excel Worksheet Functions | |||
How can I make a cell a certain color dependent on number value? | Excel Discussion (Misc queries) | |||
How can I make the graph omit blank cells in the data set? | Charts and Charting in Excel | |||
REPOST: How can I make the graph omit blank cells in the data set? | Charts and Charting in Excel | |||
how do I insert drop down menus into excel that are dependent on . | Excel Discussion (Misc queries) |