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.


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.

Please help. Thanks so much

Test File.xlsx