How do I add formulas to additional rows of my Google sheet automatically?

Question

All my rows have the same formulas. I want it to be copied to the newly added rows automatically. Sheets provide us with 1000 rows initially and an another 1000 or so can be added subsequently as per requirement. I want sheets to automatically copy paste formulas to the newly added row.

You may want to consider the use of Arrayformula() instead of single-cell formulas. If you need more help, please share a copy of you spreadsheet. — JPV
– JPV, Commented May 22, 2019 at 5:42
Can arrayformula be used along with vlookup function also ? if yes, how is the syntax modified ? — Suraj S
– Suraj S, Commented May 22, 2019 at 6:05

JPV · Accepted Answer · 2019-05-22 06:43:50Z

2

I couldn't edit the sheet (because of protection on the sheet) but try clearing out alll contents of column T and then enter in T1

={"SPOT SURVEYOR'S MOBILE NO"; Arrayformula(if(len(S2:S), IFERROR(vlookup(S2:S,$EE$2:$EO,5,0)),))}

and see if that works?

answered May 22, 2019 at 6:43

JPV

27.4k4 gold badges37 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How do I add formulas to additional rows of my Google sheet automatically?

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related