| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change cell based on answer in another cell
I am trying to make a cell have an "x" marked in it if another cell has a
certain word in it. Example: F2=George then A14=X, If F2=Mary then A15=X. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change cell based on answer in another cell
Try this:
=CHOOSE(MATCH("x",A14:A20),"George", "Mary","Alice", "Jane","Albert","Berak","Hillary") best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Ryan" wrote in message ... I am trying to make a cell have an "x" marked in it if another cell has a certain word in it. Example: F2=George then A14=X, If F2=Mary then A15=X. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change Text Color in one cell based upon entry in referenced cell | Excel Discussion (Misc queries) | |||
| Copy a cell based on check box answer | Excel Discussion (Misc queries) | |||
| Change Currency Format of Cell based on another Cell | Excel Worksheet Functions | |||
| How to change cell text based on another selected cell? | Excel Discussion (Misc queries) | |||
| How do I change cell color based upon data range within the cell? | Excel Worksheet Functions | |||
Linear Mode
