I have an excel file and I created a power query within the Excel file. The query has over 300k record so I don't want load the data into a dynamic table then use a vlookup because it will take too much time to wait for all data to load.

My question now is, is it possible to create a lookup data using VBA to look in that query?
Something such as
Please Login or Register  to view this content.