Changing column when copying downwards in excel

[Ogo001]

Hello,I am working in excel and using this simple function. =MATCH("x";Sheet1!J$6:J$13;0) When dragging downwards i want the column to change, but not the numbers. Like this =MATCH("x";Sheet1!J$6:J$13;0) =MATCH("x";Sheet1!K$6:K$13;0) Is there anyway to make this automatic while dragging down?

<tbody>
</tbody>

 

[FormR]

Hi, welcome to the forum - you can try like this:

=MATCH("x";INDEX(Sheet1!$J$6:$AA$13;0;ROWS($A$1:A1));0)

Extend the AA column to the maximum needed and change the A1 references to the cell reference that you first enter the formula.