I'm having a hard time getting it to work for me.. but do you thing you get my problem I'm struggling to explain?

I'll try to make it simple, even I get a headache understanding it..

So, I have two columns, about 11100 rows long. Column A is a certain product sorted by date sold. Column B shows the price for the products in Col A.

There is about 1000 different products, and the same product tend to show up multiple times in Col A (same type of product sold on a different date).

Now on there are places in Col B that is showing 0 as price, which is incorrect. So I want to find the same product in another row and take the price, just to replace the incorrect 0!

Then find next 0 in Col B, and start over:

1. identify the product nr in Col A (say the prod. nr. is 1122) thats in the same row as the 0 in Col B, meaning that it is missing its price.
2. find another row with the same product nr as in 1. (we said 1122) but WITH the product price in Col B
3. take that price and copy it back into the Col B in 1.

Next zero in ColB