Formula for if specific contains text

[Closed]
Report
Posts
1
Registration date
Wednesday January 11, 2017
Status
Member
Last seen
January 11, 2017
-
i am looking after purchase dept. kindly send us formula that one column contains text"BUY" and i want paste some columns in other sheet. Means cell z contains text buy then i want to past cell a to f. Please show is there any formula available for this.