I making a sheet that assigns territories to an account based on the State. When using the vlookup to match the state to the territory, I continue to get a "#N/A" error even though the states match. When change the formula to look for an approximate match it generates the wrong value. I've attached an example of what I'm working on.
Thanks in advance for suggestions