Return previous answer to different column

[nedim_b]

Hi,

I have a first table QUESTION with the column : Are you a man or a woman?

I have a second table ANSWERS where I would like, in a virtual column, return the answer from that previous question in text format.

Is there an expression for this ?

Thanks a lot !

[LeventK]

help.appsheet.com

LOOKUP()

Get column value from row in table or slice

help.appsheet.com

References Between Tables

Learn about references, when to create them, and how to use them so your data makes sense.

help.appsheet.com

Dereference Expressions

Use a dereference expression to retrieve a field value from a referenced record.

[Steve]

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT() Tips & Tricks 💡

How do I get a column value from the last row of this thing only? LOOKUP( MAX( SELECT( My Table[_ROWNUMBER], ([_THISROW].[Thing] = [Thing]) ) ), "My Table", "_ROWNUMBER", "Wanted Column" ) Replace My Table with the name of the table from which you want the column value; Thing with the name of the column containing a value that identifies the thing you want (e.g., Order ID); and Wanted Column with the name of the column whose value you want. See also: MAX()