Adding text to a cell based on an answer in another cell

[Ryan]

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.

 

[Niek Otten]

In A14:

=IF(F2="George","X","")

In A15:

=IF(F2="Mary","X","")

Note that thes formulas are not case sensitive. If you require them to be,
use the EXACT function instead of the = comparison operator, as in:

=IF(EXACT(F2,"Mary"),"x","")

 

[Bob Greenblatt]

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.

Ryan,

Niek gave you a good solution, but I detect that you may have a conceptual
issue. In Excel, one cell can NOT alter the value of another cell. So in
your case, you will need a formula similar to what Niek offered in each cell
where you want the X, and that formula need to refer to the 'source" cell in
order to set its value properly.