Dear all,
Please consider the following situation.
I have two tables related to each other via one field. It is a one to many relationship. Let's call the table on the one side 'singleTable' and on the many side 'manyTable' and the linked field in the relationship 'link'.
In singleTable I would like to return a field from manyTable called 'returnValue', based on the relationship that exist via ‘link’. However, as it is a one to many relationship, multiple matching ‘returnValue’s exist and they are non-unique.
Thus, I understand why =RELATED(returnValue) gives an error.
Let’s say I would like to return the n-th value of the multiple matching ‘returnValue’s. What do we do? My idea is to use =RELATEDTABLE(manyTable), however this returns a table whereas I need a single value. How do I get the intersection of n-th row and the column with name ‘returnValue’?
Many thanks in advance.
Please consider the following situation.
I have two tables related to each other via one field. It is a one to many relationship. Let's call the table on the one side 'singleTable' and on the many side 'manyTable' and the linked field in the relationship 'link'.
In singleTable I would like to return a field from manyTable called 'returnValue', based on the relationship that exist via ‘link’. However, as it is a one to many relationship, multiple matching ‘returnValue’s exist and they are non-unique.
Thus, I understand why =RELATED(returnValue) gives an error.
Let’s say I would like to return the n-th value of the multiple matching ‘returnValue’s. What do we do? My idea is to use =RELATEDTABLE(manyTable), however this returns a table whereas I need a single value. How do I get the intersection of n-th row and the column with name ‘returnValue’?
Many thanks in advance.