if "a" selected from dropdown menu then show "K" in other cell

L

LEGALMATTERS

New Excel User : Using a dropdown menu, in one cell, if a user selects from
"yes" or "no" then I need (in a different cell) "good" or "bad" to be
displayed ...
 
D

Duke Carey

In the cell where you want Good/Bad (assumes cell with dropdown is A1)

=if(A1="","",=LOOKUP(A1,{"No","Yes"},{"Bad","Good"}))
 
Top