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 |
---|---|
43 | |
30 | |
26 | |
14 | |
14 |