Data not refreshing when selection changes

[Hansie]

Hi all

I have a column to capture MEMNAME which is a REF from table USERS.

I have another virtual column (WALLET) to display a value based on the selection from table USERS.

I have the following formula in WALLET :
LOOKUP([MEMNAME],“USERS”,“MEMNAME”, “MEMWALLET”)

The issue I have, is when the value of MEMNAME changes, the value of WALLET does not.

Any guidance would be appreciated.

Thank you

[Steve]

You’re using LOOKUP() wrong.

See also:

help.appsheet.com

LOOKUP()

Get column value from row in table or slice