Formula for if specific contains text

bhagyeshp Posts 1 Registration date Wednesday January 11, 2017 Status Member Last seen January 11, 2017 - Jan 11, 2017 at 06:51 AM
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.