Match with a field

[Tibz]

Hello !

All i want to do is to check if there is a value called 'B' in a FIELD2 at the row 'A' in FIELD1

I've tried:

=if(match('A' , { $ <FIELD1= {'B'}>} FIELD2 ),1,0)

=if(match('A' , FIELD1 ),1,0)

don't works either

I've also tried

=if(FieldValue('FIELD1 ',fieldIndex('FIELD2 ', 'A'))='B',1,0)

But it doesnt works because there is a lot of duplicate values in FIELD1

Thanks in advance for your answering,

Regards

[Anil_Babu_Samineni · Accepted solution]

Perhaps this?

If(FIELD1='A', If(FIELD2='B', 1,0))

[Tibz]

thanks a lot !