Hello,
I have a workbook where client ID, name, address, etc is on one sheet (Cases) and the user can select the client's ID at the top of other sheets (via a drop-down with data validation for a named range) to populate the other sheets.
This works great so long as the user sticks to the list. Unfortunately, users are circumventing this by typing client IDs in the drop down. This too is ok, except for the fact that people make mistakes and type client IDs that don't exist, thus telling the computer to reference data that returns the beloved N/A# error.
E.g.: say clients are Tom, Dick and Sally. If you type "Sally" in the drop-down on another sheet, no problem. If you type "Sully" instead, her address, date of birth, etc will all appear as N/A#. HOW DO I PREVENT THIS ANNOYING OCCURENCE? Thank you for any help. I've attached an example with cartoon characters for demonstration.