Error capture for null/no search entry

  • Hi,

    So I am attempting to secure my sheet with some error capture on a certain cell A10, as this is where users are inputting search terms to filter out data to match their term.

    I had a previous error return that would check their entry against every entry in the data sheet to see if there was any match, if not then return an error.

    I am looking to do the same for if there is NO/NULL ENTRY in cell A10. Below is what I have tried but I cant seem to get it working.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!