Forum Discussion
Solved
Replicate a Formula in a column
I think this is simple but i can not remember how to do it I need to replicate a formula in all cells in column B so that if a word in a2:a13 appears in column K... then column B... is filled with ...
Use
=OR(COUNTIF(K9,"*"&$A$2:$A$13&"*"))
or
=OR(ISNUMBER(SEARCH($A$2:$A$13,K2)))
and confirm by pressing Ctrl+Shift+Enter if you do not have Microsoft 365 or Office 2021.
Use
=OR(COUNTIF(K9,"*"&$A$2:$A$13&"*"))
or
=OR(ISNUMBER(SEARCH($A$2:$A$13,K2)))
and confirm by pressing Ctrl+Shift+Enter if you do not have Microsoft 365 or Office 2021.
HansVogelaar Thank you that helped alot! i forgot that $ locks the cell choice
