I am trying to write an If statement where if a cell says Heritage I want Heritage to appear in another cell.
I am in Cell V and the cell is empty.
I want a formula in V that asks If cell I contains "Heritage" for cell V to display "Heritage" and if Cell I contains "Telus" for cell V to display "Telus"
I am pretty sure I have to use Contains Heritage and Telus as there are several connotations of those companies, but all have those terms in them.
I have tried =if(I6_contains "Heritage", "Heritage" "") and I got an error message.
Bookmarks