Lookup Multiple users details found in one column using another table

Hi SamOvermars ,

My understanding is that you want to match the id of the two tables, and the easiest way to do that is to create a relationship between the two tables:

This also establishes the relationship between the id in the task table and the username in the user table, then you can achieve what you want, like this:

If I misunderstand your meanings , please let me know in time. Thanks in advance~

Best regards,

Community Support Team Selina zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly