Discover what data silos are costing your org in our commissioned Forrester study. Learn more

Comparing Look-up Fields

Topic Labels: Formulas
259 0
Showing results for 
Search instead for 
Did you mean: 

Hi All,

I have question regarding creating a 3rd column by comparing following two columns;


I want to have a 3rd column which shows what is the common item for the both first two columns. So if we take above image as the example, in the new column it should only show “Knitting” on 3rd row and leaving other rows empty. In this scenario there is only one value (comma separated) on first column, but in can have multiple values in some cases. However it will only have one common phrase for a given row.

Your help will be much appreciated :grinning_face_with_big_eyes:
Thank you in advance :pray:

-Eranga Perera

0 Replies 0