Hi @matthew.wright,
Power Query VLOOKUP is actually done by merging tables. Makes sense if you think about it, after all a VLOOKUP is simply pulling a column from one table into another table. To quote this article which describes it quite well IMO.
https://www.myonlinetraininghub.com/excel-power-query-vlookup