Drawing values from a list dependent on user input.

[Jett Midknight]

Hello, I am working on a side project in excel and I have run into a snag. Currently I have is so the user can select a text value from a droplist. I want to know if it is possible to then generate value in other cells that corresponds with the user input. For example, in the below picture if the user selects A from the dropdown list I want the cell next to the list to return Apple. Is this possible? I know you could just tell the cell to return Apple if A is selected specifically, but I am dealing with several hundred entries here, and don't want to code each of them in individually
.