I have a current drop down list. I can pick something from it and it populates another cell just fine. Now I need that Drop down list to continue to do that but then I need it to populate different information in a different cell. I ask this because the drop down list is very long and did not want to have to duplicate it for another drop down list to fill this other cell. So in another way I need an item from the drop down list to say populate a price in cell B7 that it gets from another sheet and then I need it to populate say speed/feed rate in cell M9 that will allow me to use a formula in another cell to give me an answer.