i'm having hard time figuring out why formula below won't parse when passed sheet.getrange('b2:b').setformular1c1(). works in sheet when replace r1c1 notation a1 notation , nothing else.
formula: if(r[0]c[4]="", "", vlookup(r[0]c[4], sheet2!a:b, 2, 0))
this 1 works: if(f2="", "", vlookup(f2, sheet2!a:b, 2, 0))
the difference being replacement of r1c1 notation.
because script populating column r1c1 notation still there (it should replaced column referenced in a1 notation knowledge), believe problem lies .setformular1c1() function itself.
i've got (different) formula same syntax using ranges working directly above using same function. yet 1 not parse, , have no idea why.
any appreciated.
turns out cannot mix a1 , r1c1 notation. correct formula evaluates properly:
if(r[0]c[4]="", "", vlookup(r[0]c[4], sheet2!c[-1]:c[0], 2, 0))
note r1c1 notation has replaced a1 notation in second sheet reference.
Comments
Post a Comment