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.
- Your answer.
- The list of letters that the answers correspond to.
- 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.