| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Place X in cell if criteria met`
Is there a formula to do this?
If cell B2 = pencils Put an "X" in cell B7 If cell B2 = pens Put an "X" in cell B8 If cell B2 = erasers Put an "X" in cell B9 Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| returning blank cell in criteria o | Excel Discussion (Misc queries) | |||
| I am trying to color fill a cell based on specific criteria | Excel Discussion (Misc queries) | |||
| Formula to return ADDRESS of cell in range that meets criteria | Excel Worksheet Functions | |||
| "criteria" in a sumif refering to the value in another cell | Excel Discussion (Misc queries) | |||
Threaded Mode
