excel - Select and Insert if two conditions are met -


we trying create conditional statement not sure begin. logic this:

if (col.a = col.b) , (col.c = col.d) select data col.g , insert col.h

assuming have headers or titles @ top of columns, enter formula cell h2:

=rept(g2,(a2=b2)*(c2=d2)) 

Comments