If you have Sheet1 and Sheet2 insert this formula somewhere in Sheet2



=IF(Sheet1!A1="","default wording",IF(Sheet1!A1="anything","anything",""))

Thanks xor. However, I dont want the literal word, "anything". Im actually working with addresses, and the default wording is "New Zealand". However, in some cases I want to send to a country overseas. So, I may type the word, "Australia" or "United Kingdom" or "Germany". In those cases I want the cell in sheet2 to return the same word that I typed in sheet1.

Sorry that my O.P. wasnt clearer. Can you suggest again?