Vlookup Exception Or Macro to Deleting Cells if Certain Value Present

Test File.xlsx

Okay so this is a very simplified version of my actual file. What i have in my actual file are many rows, for which I want many outputs using vlookups. I figured out how to do that. So just like in this file, there is a cell which says "NOT ACCEPTED", and since it says that, I do not want it to look up that value. OR if it does lookup that value, do a macro to delete the cell in the output. Further details are included in the document.

Please help. Thanks so much

Also to specify even further, in my real file, the output that I want to delete are five cells in one row, but I cannot delete the entire row. So in a sense, I need a vlookup exception to not even bring that data in, or if the data does come in the output, I need a macro to recognize it, and delete the 5 cells in the row (which are consecutive).

For the sake of simplicity, if a macro is needed you can show it by only deleting it for the one cell, as shown in the document.

Thanks