connect multiple IDs

[RE]

I have two tables. Table A contatins 6 ID fields (ResourceNeeded1.Id, ResourceNeeded2.Id, ResourceNeeded3.Id,...). In Table B I have a UserId field. What I want to do is connect the resource needed IDs to the user ID. Is there a way to connect that many IDs from two different tables? 

[v-caliao-msft]

Hi @RE,

You can use LOOKUPVALUE to get the value in result_columnName for the row that meets all criteria specified by search_columnName and search_value. Or you can use a related value from another table by using a RELATED function. Please refer to the links below.
https://msdn.microsoft.com/en-us/library/gg492170.aspx
https://msdn.microsoft.com/en-us/library/ee634202.aspx

If this is not what you want, please provide us the details result you need, so that we can make further analysis.

Regards,

Charlie Liao