Hi,
I'm wondering if it's possible to create a drop down list connected to a table that will output the corresponding number when selected.
Example:
Zone 1, 2, 3, 4, 5, 6, 7, 8, 9, 10
Price 10, 20, 30, 40, 50, 60, 70, 80, 90, 100
The drop down list will show Zone options 1-9. If 3 is selected, the following cell will output table price 30
Bookmarks