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

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


"LEGALMATTERS" wrote:

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 ...