You could add a column C to what you already have and use this to give
you a unique reference for each product code entry, i.e. put this in
C2 of your data sheet:

=A2&"_"&countif(A$2:A2,A2)

and then copy down as far as required. Then in your other sheet you
could enter 21 in cell A1, for example, and this formula in A2:

=IF(A$1="","",IF(ISNA(MATCH(A$1&"_"&ROW(A1),DATA!C :C,0)),"",INDEX(DATA!
B:B,MATCH(A$1&"_"&ROW(A1),DATA!C:C,0)))

Copy this down as far as you think you might need, then you can just
enter another product code in A1.

Hope this helps.

Pete


On Dec 5, 4:09*pm, Dave wrote:
Please help, I have work hard to make this easy to understand. (example below)

Currently, I am using a Vlookup formula to… Search through product codes for
a certain code… Then I have it return the transaction number… *
So, the product codes repeats itself whenever is involved in a transaction.