Is there a formula/conditional formatting trick for returning/duplicating a cell into a column based on a value in another column?

Is there a way to have a cell returned/duplicated into a column (the yellow highlighted column) based on a value that I put in the "Answer" Column?

I am willing to change up my spreadsheet if need be to make this work.

Solution 1:

You're going to use the function Lookup. In your example you'll enter the following into the cell following your first answer (D):

=LOOKUP(F2,$B$1:$E$1,$B2:$E2)

Breaking it down, there are 3 pieces of information this function uses.

1. Your answer.
2. The list of letters that the answers correspond to.
3. The answers.

The dollar signs ($) are placed so that you can 'click and drag' to copy the function into other cells, and it will automatically update to point at the answers in that row.