Quote:
Originally Posted by JBaker
Thanks for your example! now if i can figure it out!
Figured out how to make one list... just trying to figure out how to get other cells to link with the drop down list. as i described above, if 1 is selected start 1 will be displayed.
|
Hi Jason,
If you select the cell containing the drop-down and right-click on it, choosing 'Format Control' will show you the minimal logic it requires. It's lookup range has had the name 'prices' assigned to it, rather than using cell referencing and the dropdown actually only outputs to A2. A2's value is the row number of the matched record. The value in C2 is updated by a formula:
=INDEX(prices,A2,2)
that gets its input from A2, then looks up the second column of the 'prices' table for the corresponding value to return.