Forum Discussion
RE
Helper I
Helper Iconnect 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 I...
v-caliao-msft
Microsoft Employee
Microsoft EmployeeHi 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