How to correctly put the line number in a google sheets column cell (if the formula is passed statically)?

Question

Google Sheets

Hello
, there is a formula
=IF(ISNUMBER(A1); VLOOKUP(A1; 'Responsible'!$A:$B; 2; FALSE); "" )
when uploading to google sheets, the formula is transferred statically
=IF(ISNUMBER(A1); VLOOKUP (A1; 'Responsible'!$A:$B; 2; FALSE); "" )
=IF(IDNUMBER(A1); VLOOKUP(A1; 'Responsible'!$A:$B; 2; FALSE); "" )
=IF(ISNUMBER(A1); VLOOKUP(A1; 'Responsible'!$A:$B; 2; FALSE); "" )
that is, the line number does not change
Tell me how to change the formula to pull data from the desired line?
=IF(ITNUMBER(A1), VLOOKUP(A1, 'Owners'!$A:$B, 2, FALSE), "" )
=IF(ITNUMBER(A2), VLOOKUP(A2, 'Owners'!$A:$ B; 2; FALSE); "" )
=IF(ISNUMBER(A3); VLOOKUP(A3; ' Responsible'!$A:$B; 2; FALSE); "")
=IF(ISNUMBER(A4), VLOOKUP(A4, 'Responsible'!$A:$B, 2, FALSE), "" )
etc.
ps - pulling the square is not suitable)

Answer 1

Instead of A1 in the formula, write INDIRECT("A"&ROW())