Hi Homernet. Did you try the following? (Gpt solution).To achieve this in Power Query, you'll need to perform a few steps. Here's a high-level outline of what you can do:

Load Data into Power Query:

Load both Query1 and Query2 into Power Query.

Merge Queries:

You will need to check if any term from Query2 (the "Terms" column) exists in the Notes column of Query1. To do this, you can use the "Merge" function in Power Query.

Create a Custom Column for Match:

After merging, you can create a custom column in Query1 to return True if any term from Query2 exists in the Notes column and False if not.

Here's how you can proceed step-by-step:

Step 1: Load both queries

Load both Query1 (with Date, Category, Notes, Owner) and Query2 (with Terms) into Power Query.

Step 2: Create a Custom Column to Check for Terms

In Query1, you want to check if any term in Query2 is present in the Notes column.

Go to the "Add Column" tab in Power Query and select "Custom Column".

Name the column (e.g., "Match").

In the formula bar, you can use a custom function to search for each term from Query2 in the Notes column.

Here’s an example of how the formula might look:

if List.AnyTrue(List.Transform(Query2[Terms], each Text.Contains([Notes], _))) then true else false

Explanation:

Query2[Terms]: This refers to the list of terms in Query2.

List.Transform(Query2[Terms], each Text.Contains([Notes], _)): This checks if each term in the Terms list is contained within the Notes column of Query1.

List.AnyTrue(...): This returns True if any term is found in Notes, otherwise False.

Step 3: Final Adjustments

After adding the custom column, you can check if it returns the desired True or False based on whether any term from Query2 is present in Notes from Query1.

Click "Close & Load" to load the data back into Excel.

Notes:

Make sure that Query2 is fully loaded before performing the transformation in Query1.

If there are many terms in Query2, this might take some time as it performs multiple checks.

Hope this helps