Drag formula across columns

[dji]

I want to do an exact match of 3 pairs of columns with values
row a and b,row c and d , row e and f. If i put the formula in row g for row and a and b can i drag the formula across h and i for the other 2 pairs of columns to save doing it manually
thanks

 

[Skybluekid]

You need to make the cell reference semi absolute - Look at this : Relative and Absolute Cell Referencing in Microsoft Excel - YouTube

 

[dji]

You need to make the cell reference semi absolute - Look at this : Relative and Absolute Cell Referencing in Microsoft Excel - YouTube

can you help me with the formula
i know that in column g the formula for column a and b would be exact(a1,b1)
so what would i put into the formula for exact(c1,d1) and exact(e1,f1) to drag across column h and i
appreciate your help
thanks

 

[Skybluekid]

I am not too sure what you want, could you post some data to illustrate what you mean.