Trying to create a formula to check if one field (text) contains another field (number) within a record

Hi Guys,
Having trouble finding out how to write a formula to check if one field contains another field’s data. The specific use case is data being pulled from an ecommerce site. Each order comes from a page dedicated to a suburb/postcode. Each order populates a record with this suburb/postcode in one field as well as the delivery address in another field. I am trying to create a formula that will check if the delivery address contains the same postcode in the other field (and if so label it “true”).
Any help would be much appreciated!
Thanks in advance!

Hi @Paul_Townsend, welcome to the forums!

I think what you’re looking for is something like this:
IF(FIND( {Suburb/Postcode}, {Delivery Address} ), "True")

If you want to add a label for when it is false, just add it like this:
IF(FIND( {Suburb/Postcode}, {Delivery Address} ), "True", "False")

1 Like

Thanks a million Nick, that has done the trick! Was trying with the search function instead of the find!

1 Like

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.