使用IF和VLOOKUP获取excel中的#N / A.

I have a database & order request in excel. I want to set the format across all the database quantity column, so that when quantity is entered in the order request, using vlookup, it finds the code in the request form and matches it with the database and adjusts the database quantity. It works fine it there is a code already in the request form. But if the request form is blank, it throws back #VALUE! its doing my head in for hours heres what i have:I have a database & order request in excel. I w