Drop Down List Help

[JMan_12]

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

[gmr4evr1]

It's possible, see attached
Jman_12 Drop Down List Help.xlsx

[mehmetcik]

For example:

If you want to use A2 then Select A2 and then select the Data Tab.

Select Data Validation and then under Allow select List,

Click on ignore blank, Click on In Cell Dropdown.

In Source enter: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10

This will let you enter 1 to 10 in A2.

in B2 enter this formula:

Please Login or Register  to view this content.

[alansidman]

Since this is in the Access Forum, I am assuming it is an Access issue. If I understand your issue, then maybe this may be what you are looking for:

http://baldyweb.com/Autofill.htm

[gmr4evr1]

Good eye Alan....I didn't even notice it was posted in the Access forum.

[Angela3]

Thanks guys. Your posts helped me as well.