Hello excel community,
I would like to request assistance on a sheet I am making. I hope that it's possible to create the thing I need, and that there is anyone here that can help me out.
I think it would be the best to show you with an image, but I am not allowed to post images or links yet. I have tried to show te situation I'd like to create below:
Values wanted to show
25
60
50
Drop down menu choice: A
A= 25/60/50
B= 40/50/80
C= 50/65/90
I have one table with multiple values. Each of the choices represents a series of values. I'd like to have the values automatically change to the values below A, when this option is selected in a drop down menu. I don't know if this is possible in excel, but I'd be glad to get some help if it is!
Thanks in advance,
Mark
Bookmarks