Hi, sorry I am sure that is poor title. But here is what I would like to do. I have a column of our all of our part numbers sorted by volume highest to lowest (30,000 skus). Next to it, I ran a sequence all the way down, 1-30,000. and next to that I have group of items that I want to know where they fall on the best seller list.
Column A: Open right now
Column B: Group of random Skus
Column C: Sequence of 1-30,000 (C2: 1, C3: 2...)
Column D: Skus ranked highest to lowest. Best selling sku is in D2 down to lowest in D30000
I would like to associate column B against column D and have the related number in Column C be shown in Column A. If that makes sense.
Bookmarks