I have a formula that checks three columns in a table to find matching data. It looks like this:

=IF(OR(AND(ISNUMBER(SEARCH(" at ",Master[@[Organization Name]])),ISNUMBER(SEARCH(" at ",Master[@[Work Location]])),ISNUMBER(SEARCH("Austria",Master[@[Work Country]]))),...),"correct","incorrect")

Since this line goes for 60 countries, I have reached the cell character limit, so I’m wondering whether there is a way to merge the search function into one, so I could save some space.

=IF(AND(ISNUMBER(SEARCH(" at ",Master[@[Organization Name],[Work Location]])),ISNUMBER(SEARCH("Austria",Master[@[Work Country]]))),"correct","incorrect") 

This of course does not work but you guys may have an idea how to make it work.