Need to have a cell display text based onentries into another cell

[Dinger1216]

Version: 2004

I am looking for a formula that will allow me to have a cell on one worksheet display text based on the user input on a cell in another worksheet.

For example, if user enters "S" in C53 of worksheet January, I would like to see "S" in "D7" of worksheet Summary and if the user enters "H", I would like to see "H", etc.

I cannot use "Paste Link" as I do not want all text to transfer over (ex: if user enters "X", then I would like the other cell to stay blank).

Thanks!

 

[JE McGimpsey]

Version: 2004

I am looking for a formula that will allow me to have a cell on one worksheet
display text based on the user input on a cell in another worksheet.

For example, if user enters "S" in C53 of worksheet January, I would like to
see "S" in "D7" of worksheet Summary and if the user enters "H", I would like
to see "H", etc.

I cannot use "Paste Link" as I do not want all text to transfer over (ex: if
user enters "X", then I would like the other cell to stay blank).

One way:

=IF(OR(January!C53="S", January!C53="H"),January!C53, "")


Another:

=IF(SUM(COUNTIF(January!C53,{"S","H"})),January!C53,"")