Hi Guys, I know there a good few posts about returning multiple match values, but non of them worked for me... and after a few days of research I hit the brick wall...

Anyway, I'm hoping this as my last resort to solve this massive puzzle piece...

I'm attaching the file so if someone is attempting to solve this will have full file layout.

So, step 1: I going to have a VBA script to pull file names from the folder and files names will apped in column D3 to D..... (VBA script is done)

Step 2: Index and match formula will find a MASTER code for VARIANT code that was retrieved. So for example in this sheet 122928923 is variant and 119707775 is a MASTER for this VARIANT. Then SKU count will count how many MASTER codes are for this specific master code. In this case 10.

Now this is the part I can't get to work!

Step 3: Variant code form cell D3 will be copied 10 to COLUMN A2 to A11 (10 times)

Step 4: All 10 CODES for MASTER 119707775 needs to be copied over to B2 to B11 (10 different CODES)

Step 5: IF D4 is not blank, repeat STEPS 3 and 4...

Does anyone had anything similar to build or at least knows how to get STEP 3 working and them will look for step 4... I'm totally lost here...

https://www.dropbox.com/s/japh2d1hqo...NAME.xlsx?dl=0