I have a drop down menu set up that references a list of data from another worksheet. When I select an item I want the prep time to show up automatically in the cell to the right of it. I’ve got it set up where you can select a model and then in the cell to the right drop down another list to pull the one value that corresponds with the selection. Instead of having to manually select the corresponding value can you have it automatically appear? Help me!
Thanks!
