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