Hi Everyone,
I have a spreadsheet formula
XLOOKUP(RC[-40],'SHEET1'!B:B,'SHEET1'!R:R)
When new record is generated, it becomes
=XLOOKUP(E158,'SHEET1'!B:B,'SHEET1'!AT158)
is it a bug?
Try using R1C1 notation throughout the entire formula.
User | Count |
---|---|
37 | |
30 | |
29 | |
20 | |
18 |