Hi, here is a sample of my table
TrackingNum ----- GoldNumber
2010836994 ----- 16701
2010836994 ----- 16702
2011000954 ----- 16686
2011000954 ----- 16687
i want to use vlookup (or any other method) so that on another sheet one tracking number will display both gold numbers attached to it.
the new sheet doesnt display duplicate tracking numbers btw.
thanks!
Bookmarks