This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Wrong Spreadsheet formula generated with R column

Posted on 02-24-2023 08:04 PM
Jim_Ho
Bronze 3
Bronze 3
Reply posted on --/--/---- --:-- AM

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?

0 2 86
Topic Labels
0 Likes
2 REPLIES 2

Posted on --/--/---- --:-- AM
dbaum
Gold 4
Gold 4
Reply posted on --/--/---- --:-- AM

Try using R1C1 notation throughout the entire formula.

Posted on --/--/---- --:-- AM
Steve
Platinum 4
Platinum 4
Reply posted on --/--/---- --:-- AM

Spreadsheet formulas - AppSheet Help

Top Labels in this Space