How to Make a cell Display a certain word, when another drop down cell is a certain value (Excel)

But there are 8 different settings, basically there is a drop down cell which has 1 - 8
which represents candidates, and there is another cell which displays the name of the cadidates. so would a true false still work if there are 8?
 
You must log in or register to reply here.
Back
Top Bottom