cant get IF command to work

I'm trying to make a certain cell contingent on two different cells using the IF command. My formula is IF(G28="#REF!",G34,G28). where G34 contains the word "steel".   The goal is that if the value...