Hi Guys, very novice with excel.
Create a spreadsheet with drop down menus.
I am trying to make this a very easy sheet here is what I am trying to do...
Cell A1 will have a drop-down menu.
I would like it to auto fill Cell B1 based on the selection of cell A1.
Tricky part is, I do not want it to auto-fill with the same word from A1. I would need it to auto-fill a pre-determined code based on the selection of cell A1.
Lets see the pre-determined words are...
Apple = Orange
Cat = Dog
Green = Yellow
If I select Apple in cell A1 it would auto fill B1 with Orange
If I select Cat in cell A1 it would auto fill B1 with Dog
If I select Green in cell A1 it would auto fill B1 with Yellow
Hope that is clear enough.
Bookmarks