Comparing Look-up Fields

Topic Labels: Formulas
616 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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