Does it still happen using this alternative ?

=$D862*lookup($d862,{0,50,150,700,1000,2000,3000}, {J$2:P$2})

Maybe post a sample sheet with some of your data showing the problem?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post