Perform a Lookup with Power Query

Channel Avatar
Comment
X
Share
Perform a Lookup with Power Query
Perform a Lookup with Power Query
This video show how to use Power Query to perform lookups. For small data sets you are better off with Excel’s other lookup function, but if you are dealing with large data sets (over half a million) you may be better off using Power Query. This method also would make it easier if you do this on a recurring basis (daily, weekly, etc) and didn’t/couldn’t write macros.

SUBSCRIBE to my channel https://goo.gl/wN3c3p

Excel Training https://www.exceltraining101.com/p/tr…

Excel Books & Tech Gear https://www.amazon.com/shop/dough

️ Tools: Screencasting https://techsmith.z6rjha.net/5Qe53

️ Tools: Microsoft Office https://microsoft.msafflnk.net/rKL0G

️ Tools: TubeBuddy https://www.tubebuddy.com/et101

This description may contain affiliate links and we’ll receive a small commission if a purchased is made using the links (but at no additional cost to you). It’ll support the channel and so more videos like this can be made. Thanks for your support!

If you find these videos useful and want to support my channel go to https://www.patreon.com/DoughExcel

#excel
#msexcel
#doughexcel

Take the opportunity to connect and share this video with your friends and family if you find it useful.

Keywords: tip, power query, tutorial, excel 2013, merge, msofficetrain101, excel youtube channel, match, big data, vlookup, training, lookup, powerquery, index, doug, dough, update, lookups, microsoft, learn excel

Read Also

Leave a Reply

Your email address will not be published. Required fields are marked *