Vlookup multiple returns issue with a huge data

Hello all,

I will add a sample of the data that I am using as it is more that 8K rows.

So I have a spreadsheet with some codes and products that have been purchased as follows:

Codes Product
1 Camera
1 Phone
1 Laptop
2 Screen
2 Mouse
2 Laptop
3 Camera
3 Laptop
3 Mouse
3 Screen

And another spreadsheet with returns based on the same codes.

Codes Returns
1 Phone
1 Laptop
2 Mouse
2 Laptop
3 Camera
3 Laptop

As you can see for example the code 1, returned two of the three products purchased. So I am looking for a formula to see which products are mostly being returned.

So I made a universal spreedsheet using Vlookup to see the returns based on the codes:

Codes Product Codes Vlookup Product Returned
1 Camera 1 Phone
1 Phone 1 Phone
1 Laptop 1 Phone
2 Screen 2 Mouse
2 Mouse 2 Mouse
2 Laptop 2 Mouse
3 Camera 3 Camera
3 Laptop 3 Camera
3 Mouse 3 Camera
3 Screen 3 Camera



I know that my way of thinking is not correct but can someone help me? I am really stuck.

Also how can I move to the next product in the Vlookup.

Please let me know if you have any question/suggestions to make.

I cannot check that manually..

Thank you for your time!

Hello Specia-K,

Thank you for your fast response, but I am not sure if I applied that correctly. I have tried it, however it returns incorrect information. For example the user "1" never bought a Mouse and using this formula it says that he returned a mouse.

Please find the excel attached here:
https://drive.google.com/open?id=1Dx...0qWY_aPt_K3HOk

Thank you,

Hello Special-K, You just saved the day! You are amazing! May I ask how you know all these? You are awaseme!