What I want to do is
Search through product codes for a certain code€¦ Then I have it return the
transaction number€¦
So, I created a Vlookup to do so...
(EXAMPLE BELOW)

My problem is€¦
When I use my Vlookup formula and drag it down, it will repeat the same
transaction for several rows (probably based of # of rows until the next
transaction with that product code) before listing the next transaction.
I would like for each transaction to only be listed once and in subsequent
order.
How can I eliminate this repetition€¦

Example- Searching for product code 21€¦
DATA SHEET
A-Product Code B-Transaction #
18 AX144
21 AT888
55 BT444
89 EE789
21 BW123
10 CR559

VLOOKUP FORMULA SHEET
A- (=Vlookup(21, A1:B1000, 2, false)
AT888
AT888
BW123
BW123
BW123

WHAT I WOULD LIKE IS JUST:
AT888
BW123