Same wareID with different prices

Hey, 

I have a bit of an interesting (perhaps simple) predicament, where I have duplicate values in my dataset because some WareIDs have different prices depending on the amount sold. See example below; 

I.e. WareID in column 1 24070262 appears twice, because it has two different prices depending on the amount sold. Is there a way to get the second price (8,71) into the NewColumn, if the price is 10? (in order to "eliminate" the problem with duplicates)  

Alternatively, am I overthinking it and is there a more simple solution?