Comparing two lookup columns

Doesn’t change my answer, but if it helps, create a template column in the related sheets that joins whatever value you are using for the relation, with the column value that you have in your existing lookup. Use that template as your lookup against the first relation. Then use that lookup to create your second relation.

1 Like