Hello

there is a formula

=IF(ISNUMBER(A1); VLOOKUP(A1; 'in charge'!$A:$B; 2; FALSE); "" )

when loaded into google sheets formula is transmitted static

=IF(ISNUMBER(A1); VLOOKUP(A1; 'in charge'!$A:$B; 2; FALSE); "" )

=IF(ISNUMBER(A1); VLOOKUP(A1; 'in charge'!$A:$B; 2; FALSE); "" )

=IF(ISNUMBER(A1); VLOOKUP(A1; 'in charge'!$A:$B; 2; FALSE); "" )

that is, the line number is not changed

Tell me how to change the formula that would pull data from the rows?

=IF(ISNUMBER(A1); VLOOKUP(A1; 'in charge'!$A:$B; 2; FALSE); "" )

=IF(ISNUMBER(A2); VLOOKUP(A2; 'Responsible'!$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 - pull the box is not perfect)

there is a formula

=IF(ISNUMBER(A1); VLOOKUP(A1; 'in charge'!$A:$B; 2; FALSE); "" )

when loaded into google sheets formula is transmitted static

=IF(ISNUMBER(A1); VLOOKUP(A1; 'in charge'!$A:$B; 2; FALSE); "" )

=IF(ISNUMBER(A1); VLOOKUP(A1; 'in charge'!$A:$B; 2; FALSE); "" )

=IF(ISNUMBER(A1); VLOOKUP(A1; 'in charge'!$A:$B; 2; FALSE); "" )

that is, the line number is not changed

Tell me how to change the formula that would pull data from the rows?

=IF(ISNUMBER(A1); VLOOKUP(A1; 'in charge'!$A:$B; 2; FALSE); "" )

=IF(ISNUMBER(A2); VLOOKUP(A2; 'Responsible'!$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 - pull the box is not perfect)

asked March 12th 20 at 08:10

1 answer

answered on

Solution

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

Find more questions by tags Google Sheets

Works! Thank you very much - will commented on March 12th 20 at 08:15