Values of a column in X1 in table X to be equaled to the value of Column Y1 in table Y

[egmv_appsheet]

I need to know the expression to use to make duplicate of column value

where the Values of a column in X1 in table X to be equaled to the value of Column Y1 in table Y

Where the data entry shall be in table Y, column Y1

[Steve]

help.appsheet.com

LOOKUP()

Get column value from row in table or slice