Forum Discussion
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 S...
pvkvimalan SOLVED: Found a solution from Excel Forum.
=IFERROR(INDEX(B:B,AGGREGATE(15,6,ROW($A$3:$A$50)/($A$3:$A$50=E3),COUNTIF($E$3:E3,E3))),"")