FIND
Formula Explanation
Returns an array that satisfies a condition, finding all results that match the condition.
Formula Syntax
Enter in the result column: find(target column, condition, number of results to return)
The function finds all values in the target column that match the condition in the current row and returns them based on the specified number.
Usage Example
Find all values in column CS3 of the CS table where the condition is CT2 in the CT table equals CS2 in the CS table, and write the results into column CT3.
CT3 = find(cs3,cs2=ct2,2)
