How to make the formula value in the storage grid into an arithmetic series after copying

[Kuang_Yang_Kao]

Hello everyone!

Ask If you type in the A1 storage box of excel sheet 1:

=IF(OR(COUNTIF('Worksheet 2'!G26,"*ok*"), COUNTIF('Worksheet 2'!G26,"*Improved*")),"○",IF(COUNTIF(' Worksheet 2'!G26,"*"),"╳","╳"))

Type in A2 storage box:

=IF(OR(COUNTIF('Worksheet 2'!G36,"*ok*"), COUNTIF('Worksheet 2'!G36,"*Improved*")),"○",IF(COUNTIF(' Worksheet 2'!G36,"*"),"╳","╳"))

Type in the storage box A3:

=IF(OR(COUNTIF('Worksheet 2'!G46,"*ok*"), COUNTIF('Worksheet 2'!G46,"*Improved*")),"○",IF(COUNTIF(' Worksheet 2'!G46,"*"),"╳","╳"))

Then use drag to copy to A10, why the values in the formulas of A1~A10 can't become G26, G36, G46, G56, G66, G76, G86,...Arithmetic sequence

Please help. thank!

[#2]

@Kuang_Yang_Kao 

The formula hasn't survived the translation, but try changing all occurrences of G26 to

INDEX(G:G, 10*ROW()+16)