I am trying to create a form in Excel that auto-fills data when a certain selection is chosen from a drop-down list.
I have the table:
Apple | Red
Orange | Orange
Banana | Yellow
I have created a drop down box that has each of the fruits and when I select that fruit I want different cell to fill the color.
I tried using the following formula:
But it did not seem to work (when I selected "Apple" it showed "Yellow" in the cell).
Any suggestions on how can I make this work?