Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Comparing Look-up Fields

Topic Labels: Formulas
280 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