Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if "a" selected from dropdown menu then show "K" in other cell
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 ... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if "a" selected from dropdown menu then show "K" in other cell
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 ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
automatic offset cell location when there is a value in a selected cell. | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
show macro security setting in a cell | Excel Worksheet Functions | |||
cell reference show cell name (ie. D45) and not cell value | Excel Worksheet Functions |