Sales Tax on Order Form

[Denise_and_Stuart_Ma (Denise and Stuart MacPherson)]

We are obliged to charge sales tax on our product based on the client’s residence. I created a table of Sales Taxes based on the “State” field on the Order Form, but someone mis-typed their state name and the tax was not added to the order. Is there a way to parse the input to validate it against the table, or to assign a default sales tax rate when the lookup doesn’t provide a result?