IF Statement to TRUE/FALSE if one field data is equal to another MULTISELECT field

Hi Ian. Here’s a quick and dirty way to do it, assuming {Item Profile} only ever has one value.

IF(
  FIND({Item Profile}&'',{Store Profile}&'') > 0,
  'yes',
  'no'
)

Welcome to the community, @Ian_Taylor! :grinning_face_with_big_eyes: To clarify something else, the fields in the screenshot that you shared are lookup fields, not multi-select fields. Lookup fields are related to link fields (which also aren’t multi-select fields). Link fields allow you to link to records from another (or the same) table, while a lookup field uses those links to retrieve specific field data from the linked record(s).

A simplified version of what @augmented shared would be to strip the IF() function away and just use the FIND() function on its own:

FIND({Item Profile}&'',{Store Profile}&'')

Any positive number—meaning that the item was found—will equate to True and return a 1, while a 0 is equivalent to False and will return a 0.