close
New Excel User : Using a dropdown menu, in one cell, if a user selects from
quot;yesquot; or quot;noquot; then I need (in a different cell) quot;goodquot; or quot;badquot; to be
displayed ...
In the cell where you want Good/Bad (assumes cell with dropdown is A1)
=if(A1=quot;quot;,quot;quot;,=LOOKUP(A1,{quot;Noquot;,quot;Yesquot;},{quot;Badquot;,quot;Goodquot; }))quot;LEGALMATTERSquot; wrote:
gt; New Excel User : Using a dropdown menu, in one cell, if a user selects from
gt; quot;yesquot; or quot;noquot; then I need (in a different cell) quot;goodquot; or quot;badquot; to be
gt; displayed ...
全站熱搜