Questions tagged [google-sheets-vlookup]
17 questions
0
votes
1 answer
insert formula in newly created rows
Hi everyone was wondering how do i insert a formula into the newly created row
this script inserts 10 new row and i would like to instert a formula in the 10 new created row in the column E
var ss = SpreadsheetApp.getActive();
var target =…
Yvan L
- 233
- 3
- 12
0
votes
2 answers
VLOOKUP a cell that does not contain specific text
Currently using this formula;
=ARRAYFORMULA(VLOOKUP("*"&$W$2&"*",H1:T1000,{2,3,5,8,11},false))
which works fine when I put something into cell W2.
However, what if I want to return all rows that do not contain that value from W2, is there a way?
itsPav
- 516
- 2
- 14
- 25