My problem is, when I use my Vlookup formula and drag is down it will list
information for a transaction several times before list the next... How can
eliminate this.

How can I have it only bring up a transaction once, and the move on to the
next?
I appreciate any help I can get...

Eample:
I look for a product code and have it return the transaction
code...(Transactions codes are I.E. TR55, TR56 TR57, etc...)

Column: Transaction Code for Product ###
TR55
TR55
TR55
TR55
TR59
TR59
TR59
TR59
TR59
TR59
TR65
TR65
TR65
et....
TR66
TR62