Data not refreshing when selection changes

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

You’re using LOOKUP() wrong.

See also: