Matching pair of values in two columns

George_Jokha You're welcome 🙂🙂

George_Jokha See attached file.

I added a group counter in column K. Note K36 telling that that group number is not in use (zero times correct since A45 has 01312 in column B and thus belongs to group 10 on row 11).

ie, make sure that the logic is the way you want it to be.

-/-

I have extended the formula in c2 to use from a2 and end downwards, like Ctrl+Shift+Down Arrow.

endDown(a2) may be changed to A397 but will then not follow dynamically. And same for endDown(B2).

=LET(prod1;A2:endDown(A2);
     prod2;B2:endDown(B2);
match1;    XLOOKUP(prod1;I3#;OFFSET(I3#;0;1));
match2;    XLOOKUP(prod2;I3#;OFFSET(I3#;0;1));
output;    IF(match2<match1;match2;match1);
output
)

endDown is a workbook local function built with the function LAMBDA. If you copy a cell using such function and paste it in another workbook, it will follow and be functional but as of 2022, only with 365.

The (long) formula for endDown is located in the name manager (Ctrl+F3).

bosinander I'm newby here (I'm active in Power BI community mainly), so, unfortunately, I could not find the corresponding upload (attachment) button. What I can do is to provide the list in a table: