Need Formula to find the match then copy & paster number

Originally Posted by tuongtu3

Hi benishiryo,
Just found out that the formula does not get result when qty does not match. Please take a look at cell W3 and W16 in attached file.

Regards,
tt3

Maybe conditions of the data rather ambiguous? "cell W16 should be 1" Why?