I am trying to transfer text from one sheet to another. Cell C18 needs to autofill D118 on another sheet. However, D118 needs to stay blank if the text reads NR on C18, any other text should transfer. I have looked at so many websites trying to find the right formula, but nothing seems to look for the one text I don't want to transfer.
