• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Separate solution for Vlookup with blank cells versus #N/A


New Member
Looking for a solution on a VLookup. I know how to get rid of the #N/A by using an iferror statement but want Excel to continue to show #N/A for those results that do not match so I can review them and get them corrected/added to the lookup. For the blank cells in the target column, I want the results to be the text "Not Defined".