Hi, welcome to the forum

You cannot use a formula to put stuff in other cells, formulas only affect the cell they are in.

You could, however, put a formula IN those cells where you want the data to show
If A1 contains your "switch", in B1 you could have =if(A1="switch","AG","")