Match records between 2 data sets - what is the best way to approach? (Nested Loops)

[mlauber71]

@larine One idea could be to store the results at the end of a loop in a CSV file (append) and reload the file at the start of each loop - use that file to exclude matches already used.

Outside each inner loop you would have to reset (delete) the csv

Help needed with Multi row formula

OK I hope I finally got this. With two loop nested into each other and (again) not using the recursive loop but storing the data in between into a temporary file. The workflow assumes the start of an inner loop is an empty cell (one empty cell) or a “?”. Otherwise it may throw an error. I tested it against your target list and the positions do all match. [image]