Linked Cells €“ If Statement
 

I am trying to set up an If Statement so that if Cell A2 has an 11 inside of
it, whatever contents are in cell H2 will also appear in cell K2.

This is the IF Statement that I have in cell K2,
=IF(Sheet1!A2="11","H2",""), but in cell K2 the text €œH2€� appears instead of
the contents in cell H2. I understand why that's happening but I don't know
how to fix it. Any thoughts?

Linked Cells €“ If Statement
 

Just remove the quotes from around "H2".

=IF(Sheet1!A2="11",H2,"")

The quotes tell Excel to treat what is inside as literal text.

HTH
Elkar


"Workbook" wrote:

I am trying to set up an If Statement so that if Cell A2 has an 11 inside of
it, whatever contents are in cell H2 will also appear in cell K2.

This is the IF Statement that I have in cell K2,
=IF(Sheet1!A2="11","H2",""), but in cell K2 the text €œH2€� appears instead of
the contents in cell H2. I understand why that's happening but I don't know
how to fix it. Any thoughts?

Linked Cells €“ If Statement
 

Wow, it was right under my nose. Thanks Man, I appreciate you're help.

"Elkar" wrote:

Just remove the quotes from around "H2".

=IF(Sheet1!A2="11",H2,"")

The quotes tell Excel to treat what is inside as literal text.

HTH
Elkar


"Workbook" wrote:

I am trying to set up an If Statement so that if Cell A2 has an 11 inside of
it, whatever contents are in cell H2 will also appear in cell K2.

This is the IF Statement that I have in cell K2,
=IF(Sheet1!A2="11","H2",""), but in cell K2 the text €œH2€� appears instead of
the contents in cell H2. I understand why that's happening but I don't know
how to fix it. Any thoughts?