Trying to use Build list dereferences

[robbertzalm]

I trying to transfer one ID value from table A to a column with ID from table B.

What is wrong here?

I have also tried:

But here is says it cannot compare type list to text while both columns are set to the type text.

Can anyone help me out what I am as a beginner missing here?

[BHUVANESH · Accepted solution]

use this formula

LOOKUP([_THISROW].[Viswanvangst_id],"vistag","visdag_id","visdag_id")

[robbertzalm]

Thank you very much. You r help is very much appreciated