Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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')
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')
Hi Sunny,
Thanks again for helping me with a right solution.
Regards,
Pooja
Not a problem