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.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]