Replicate a Formula in a column

[gtwomedia]

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 true

Formula

=OR(COUNTIF(K9,"*"&A2:A13&"*"))

I thought is was shift or cntl + down arrow but that is not working

When I drag th botton right dot, it changes the a2:a13 values

[#2 · Accepted solution]

@gtwomedia 

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.

[#3]

@Hans Vogelaar Thank you that helped alot!  i forgot that $ locks the cell choice