VLOOKUP in Power Query: Power Query VLOOKUP or XLOOKUP alternative (error free VLOOKUP method?)

This beginners tutorial looks at excel power query and using it as alternative to VLOOKUP or XLOOKUP. Power Query VLOOKUP / Power Query XLOOKUP can help reduce the risk of errors in your workbook and is quick and simple to do. Overall, power query transformations help to speed up work in excel and for this trick advanced power query isn't needed.

This power query tutorial is one of our excel power query training videos - check them out and let us know what else you would like to see! We've already looked at topics like grouping data with power query and combining multiple tables.

0:00 Introduction
0:37 Recap on VLOOKUP and XLOOKUP
1:47 Loading data in power query
2:57 Combining table data (lookup alternative)
3:59 Loading data
4:29 Adding new data
5:03 Updating your query

Learn Excel online for free: Our Excel for beginners tutorial will teach you all you need to know to take you from zero to Excel hero!

What Microsoft Excel tips and tricks do you want to learn? Let me know for future videos! I'll continue to develop tutorials covering Excel basics for beginners and will build up a catalogue of free Microsoft Excel course materials! :-)

Check out our other videos and playlists - particularly relevant to this video are those on power query!

Links to our specific videos on these topics on VLOOKUP, XLOOKUP and power query:

[sumardjo]

WOW
thanks simple file
for practice
thanks very much

[jpcabral]

Amazing video!
Gave me some new tools and ideas to improve my workflow.
Thank you!!