How to compare text value with textbox inside table

Can we using 2 text box compare the value ? 

I try to use IF funtion to compare value of Supplier name with value of Supplier name inside table must be same name but it always display “false”

Compare formula

 

Hi Trithot,

This process cannot be achieved with the IF function, but it is possible with the CONTAINS function.
The reason is that the IF function cannot specify a field in the table
from a field that is not in the same table as the argument of the equal sign.

With the CONTAINS function, it is possible to specify an array <string> type
as the first argument and a string type as the second argument.

IF(CONTAINS(supnametb, supname), “true”, “false”)

Could you try this out and see if it works out?