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'm inserting the link below of a dummy data for better understanding of the issue. Kindly provide me with a solution.
