NEW POWER QUERY - VLOOKUP WON'T LOOKUP

Here is what I have...

I am using Excel as Event Administration software for Auto Racing events. I have a main administration worksheet that pulls entrant data from a table via VLOOKUP function on an adjacent worksheet...

In addition, the Timing & Scoring software outputs a .txt file of the results in a tabbed, delimited file format...In prior excel versions, I was able to import this data into a specific cell, overwrite the cells on the Administration worksheet and use cell references to shoot the Car Numbers (field one on the Entrant Data VLOOKUP table) to automatically create the lineups on an additional worksheet using the same VLOOKUP table based on my formatting. 

Since they have updated the POWER QUERY, I have struggled to achieve success with this function. 

First, when importing, the data added columns and screwed up the formulae. I have since figured out how to overwrite as before. However, now, the VLOOKUP function doesn't seem to want to recognize integers. It will correctly identify drivers with car numbers that have letters intermingled (to delineate duplicate car numbers - i.e. if John Doe shows up first and he's #4, then he's #4...Jane Doe shows up second and is also #4, she becomes #4X). 

The only work-around that I have found is to go to the data and overtype the integers with the same integer and everything works fine as before.

What do I need to tell my imported data to do to re-create what it used to do on prior versions?