Match values or group of values for 2 different columns

Question

Hello everyone.

I would like to match any single value from column A that would match to a group of several values in column B and vice versa.

I suppose I need multi-row formula and probably an iterrative macro since I need to check each row for each column but I might be wrong.

Here is an exemple :

Thanks a lot for your help!

Data-test.xlsx

Yoshiro_Fujimori · Accepted Answer

@McFly ,

To make it simple, I would pick all the combinations of "3" numbers from Value B. (Not 2, 4...)

Then compare the sum of the 3 numbers with Value A.

If you want to check 2 or 4 or more numbers, you may modify the macro.

( It might be possible to parameterize the number 2/3/4..., but I would stop here as it takes more time...)

Main flow

Macro

Good night. 😪