Auto-fill Cells based on Drop Down Menu Choice

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.

If there is no duplicate value of each of the value in A1, you can setup a table in a separate range/sheet as a reference. In cell B1, use the vlookup formula.
If there are duplicate values, the solution is be a little more complicated.

There would be duplicate values... There could be 10 rows to select for the drop down, all 10 rows could be Apple = Orange.

Any chance anyone can put this into an excel sheet to see better?

Attachment 440736Sorry, what I meant is will there be duplicate values to "Apple", " Cat", "Green", etc. Will "Apple" always equal to "Orange"

The example spreadsheet is perfect Layzme, thank you so much.

Copy of Example.xlsxI actually need help taking it 1 step.

So I made a new cell H5 with the drop down menu based values of column O. I would like to make the new cell in I5 with the value lookup based on H5. Could you fill that in for me?

Disregard that last message, figured it out. Thanks again.