Pull the subsequent data for repeat values (Vlookup/Index - Macth)

Hi,

I have a large data set with more than 15k rows. in one file (Say: File A) there is an SKU and Bin Location for all rows. And in the new file that I'm now working (Say: File B) contains the SKU number and I require to pull the corresponding Bin location. The challenge is that in File A both SKU and Bin Location will contain many repetitions. These are not duplicates but the same item can be found in the same bin location more than once. Also, the Same SKU could be located in various Bins. So I need the formula to pull the Bin Location subsequently one after other. I have attached dummy data for better understanding of the issue. Kindly provide me with a solution.

Thanks in advance

Try this:

=IFERROR(INDEX(B:B,AGGREGATE(15,6,ROW($A$3:$A$50)/($A$3:$A$50=E3),COUNTIF($E$3:E3,E3))),"")

Next time, please add the URLs of the cross-posted threads (see rule 3), so you don't potentially waste our time here.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.