AdWords editor has started to auto-correct keywords that have zero/low search volumes which is wreaking havoc with my VLOOKUPs. I've attached a screenshot of the keywords 'Smoothmove' and 'Evoco' which are branded terms for a client I'm working on.
if it's happening to anyone else?
The Keyword Planner is a great tool for getting keyword ideas, but it's not the most accurate keyword information you can get. It's used to get ideas and plan landing pages/ad groups, but if your specific term doesn't have enough volume, results will not be shown. A better way to get more accurate keyword information would be to use Webmaster Tools in conjunction with Analytics to show actual terms searched to reach your website, which would have more up-to-date information. But keep in mind, the Search Console has a roughly two day window for updates.
Over the Summer, Google updated the Keyword Planner to combine more terms and it made it less accurate. You can no longer search for exact matches, misspellings, or plurals using the tool and have to take the aggregate data. Hopefully Google will build a new tool to fulfill this need that many marketers have.
I'm actually seeing the old keyword information, in order to do that you need to have an active adwords account. Not sure if there is any spent threshold tho.
Or if you are trying to do keywords discovery you can easily use keywordtool.io which is a combination of adwords kw planner and ubersuggest.
If you have actively running adwords campaign, I wouldn't use SEarch console data but run a search terms report so you can real user queries reaching your site.