Hoping someone can help me with this. I have a long series of IDs in a working document to which I add a new cell every other day with a new ID. What I'm trying to do is to identify if the ID exists already in the list and if so ad the addresses to an adjacent cell of ALL matching cells so that I can easily go and find them. I was thinking of combining ADDRESS and FILTER functions to get all the results and the TEXTJOIN to combine them into a nice format within the cell. However I can't figure out a way of extracting original cell address values for a filter formula.

In essence I need to be able to pull the Cell addresses of multiple cells as long as it matches a specific criteria. The solution needs to be dynamic since the list expands by about 10-15 entries each week.

I've attached a potential outcome that I came up with, but I'm open to alternatives. The main things is somehow getting a dump of all Cell Addresses

Screenshot 2022-06-13 172419.png