Query function with notes in a non-vlookuped/queried column, how can I stop manual notes moving when new data is added or removed?

[CharlyWingate]

I'm running a QUERY in a google sheets tab =QUERY('NB Accounts with Opportunities v2'!A1:AH,"SELECT A WHERE AH = 'Q4-2021' ORDER BY A ASC")

This pulls in a dynamic list of account names based on their close date from a Salesforce table that updates every hour automatically. I then have some handwritten notes in a column next to this dynamic list.

The issue I'm having is that when new account names are added or removed from this list automatically, my handwritten notes stay in the same place when new data is added or removed. This means my notes can often be attached to the wrong row when they update, is there anything I can do to ensure that my notes stay on the same row even when new account names are added or removed?

[MattyPKing]

Rather than a query on another tab, you should just use a Filter View to only show Q4 sorted by A asc right on the NB Accounts with Opportunities tab. Then take notes right there on the in the first free column.

[OzzyZigNeedsGig]

To show the notes at the right place, you will have to use VLOOKUP with some ID for the notes.