Stock quantity range search

This is a ready program I am using answered by one of the experts here ,
It was ALKEY , was used for year end stock take for coding products while
physical count

I have now added one column the quantity column , formula on e3 do drag
down , kindly note to take into account the range f2 and G2 , since if
someone is selling to projects his quantity range search is above 500 cartons

Kindly open second attachment , first attach was a mistake