Add an apostrophe before a number entered into a form
I used an INDEX/MATCH formula in my sheet to populate the clients name on the sheet when the client number is entered on a form. When the number gets to the sheet, it returns "#NO MATCH" in the cell until I add the apostrophe before the number. Is there a way I can add the apostrophe from the form so it will validate when it hits the sheet?
Help Article Resources
Check out the Formula Handbook template!