Here's an updated file that accounts for multiple instances:

sample_sort(2).xls 26kb

http://cjoint.com/?mpdX7y67UF

Biff

"Excel_Oz" wrote in message
ups.com...
Thats Awesome!

And it works when there are multiples of the same vendor ID.

My only question now is, how do I then formulate the other columns B to
D to pick up the data pertaining to the info in column A without
duplication?

A simple Vlookup only finds and references the first instance of the
given criteria.

Thanks
Excel_Oz