Forum Discussion
connect multiple IDs
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?
1 Reply
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.aspxIf this is not what you want, please provide us the details result you need, so that we can make further analysis.
Regards,
Charlie Liao
