Forum Discussion
VLOOKUP from power query
I have a combined power query table of over 2.6 million rows. On one of my sheets I'd like to add a VLOOKUP function to extract data from this power query. Normally, when using VLOOKUP in a separate lookup table sheet, I'd reference that sheet as 'Sheet1![range]' in my VLOOKUP function. How do I do this for the reference to the power query table?
When trying to export the power query into a sheet, I'd miss about 1.6 million rows and not be able to find all data that I need.
Any suggestions?
1 Reply
In Power Query lookup is doing through merging, one the samples is here How to Perform VLOOKUP in Power Query in Excel - A Step by Step Guide (excelchamps.com)
