MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
View: 320|Reply: 9

Drop Down List Help

[Copy link]

1

Topics

1

Posts

9

Integral

Newbie

Rank: 1

Integral
9
Post on 12-13-2016 17:02:07 | All posts |Read mode
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
Reply

Props Report

5

Topics

242

Posts

565

Integral

Lord

Rank: 4

Integral
565
Post on 12-13-2016 20:25:08 | All posts



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











Reply Support Opposition

Props Report

7

Topics

603

Posts

1331

Integral

King

Rank: 6Rank: 6

Integral
1331
Post on 12-13-2016 21:48:05 | All posts



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:  


  



      =IF(A20,A2*10,)
      
      












Reply Support Opposition

Props Report

5

Topics

242

Posts

565

Integral

Lord

Rank: 4

Integral
565
Post on 12-13-2016 21:58:34 | All posts



Removed, posted twice for some reason.
Reply Support Opposition

Props Report

5

Topics

242

Posts

565

Integral

Lord

Rank: 4

Integral
565
Post on 12-14-2016 01:19:32 | All posts



Removed, posted twice for some reason.










Reply Support Opposition

Props Report

13

Topics

884

Posts

1937

Integral

King

Rank: 6Rank: 6

Integral
1937
Post on 12-14-2016 01:40:42 | All posts



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
Reply Support Opposition

Props Report

13

Topics

884

Posts

1937

Integral

King

Rank: 6Rank: 6

Integral
1937
Post on 12-14-2016 03:47:03 | All posts



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











Reply Support Opposition

Props Report

5

Topics

242

Posts

565

Integral

Lord

Rank: 4

Integral
565
Post on 12-14-2016 04:23:21 | All posts



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

Props Report

5

Topics

242

Posts

565

Integral

Lord

Rank: 4

Integral
565
Post on 12-27-2016 08:49:21 | All posts



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









Reply Support Opposition

Props Report

0

Topics

4

Posts

10

Integral

Member

Rank: 2

Integral
10
Post on 12-27-2016 10:27:33 | All posts



Thanks guys. Your posts helped me as well.
Reply Support Opposition

Props Report

Points policy of this forum

Archiver|Mobile|Small dark house|Contact us|Excel Bar

GMT-5, 9-24-2017 21:26 , Processed in 0.266568 second(s), 20 queries .

Powered by Discuz! X3

© 2001-2013 Comsenz Inc.

!fastreply! Top !return_list!