comparing two column

[#1]

Hi Friends,

Please let me know if any one can help me on the logic for the below.

I need to compare the two column values. If the values are match i need to put the message in text box " Yes there is a Matching Value " or "No Matching Value is there". It should work based on the user selection also. For ex. If user select any one record from field1 also the same condition ll work.

FIELD1	Field2
A	Z
B	B
C	X
D	Y
E	E

Regards,

Pooja

[sunny_talwar · Accepted solution]

May be like this:

=If(Sum(Aggr(If(Match(Field1, Field2), 1, 0), Field1, Field2)) > 0, 'Yes there is a Matching Value', 'No Matching Value is there')

[#3]

Hi Sunny,

Thanks again for helping me  with a right solution.

Regards,

Pooja

[sunny_talwar]

Not a problem