Fetching Id from another table

Sub Name on table B would get you to a key column (the name and sub name together) that you could do a LOOKUPVALUE on.

Hi Anonymous ,

The system does not recognize duplicate values. For each value corresponding to two results, the following four scenarios occur

If there are 2 rows with the same name in table B, you should add another condition for the duplicate value to differentiate

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.