I cannot figure out how to have Excel use logic to find data in a list like a
vlookup and then go to the next one on the list. Index & match don't work
nor does lookup or vlookup. Any ideas???

The first list would contain data like this:

Product ID # Amount Make
1111 1111-0001 $50.00
1111 1111-0010 $100.00
1111 1111-0050 $300.00
1122 1122-0022 $3,000.00
1122 1122-0024 $5,000.00
2112 2112-0002 $1,000.00
2112 2112-0066 $2,000.00
2112 2112-0099 $3,000.00

The second list contains this:

Product Make
1111 A
1111 BB
1122 C
2112 D
2112 E

I want to populate list one under the "Make" column with the information in
list two. So, for product #1111, I want it to find that product in list two
and then pull in the first Make of A. Then, I want the second item on list 1
to pull in the second item on list 2. When it gets to the 3rd product on the
list, I want to leave it blank since list two only has 2 possible options.
I'd want to be able to copy a formula on down so that it could keep doing
this.

Any ideas??