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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()