Right I know what the problem is, however I dont know how to solve it.

Basically, I pull that formula downwards and the first maybe 100 cells do not have product 1 on sheet two. Therefore, what I need to formula to do is WHEN the first condition (so product name coincide with product name) then simply take the values from the cell with sales on sheet 2. Forget about the greater than 0 thing.

The problem I am having is that I am dragging the formula down, the columns automaticaal go down and when I get down to the column where product 1 is on sheet 1 and on sheet two then excel is already much further down so it doesnt find it.

So basically everytime the product name changes I need it to start looking from the top of the spreadsheet so that the product names can coincide.

Oh god i hope i make sense! Thanks guys for your time... ant ideas?