Eliminate VLOOKUP using Excel Power Query Merge | Efficiency 365

[@pierrebodart4577]

Excellent as usual, it makes life easier & efficient ;-)

[@efficiency365]

Thanks again!
Wanted to do this video earlier... had forgotten about it...
Last week, during a live workshop, customer asked this again.
That is why I created the video.
More stuff coming soon...
Cheers.
Doc.

[@sivareddy3745]

Hi Nitin Sir, Explained very good and simple way. I thinks you may have good Experience.

[@efficiency365]

Thanks @sivareddy3745.
Yes I have 33 years of experience 😎
Check out my other best practices videos as well.
Efficient Tasks Management - ua-cam.com/video/vLFpWVfUfQ8/v-deo.html
Microsoft Teams - 15 Best Practices - ua-cam.com/video/W8Ufx_znKxI/v-deo.html
Smart and Effective Email - 5 powerful ways - ua-cam.com/video/6NEFSMqHgQE/v-deo.html
Outlook Calendar Best Practices : Part 1 - ua-cam.com/video/GzsQnecjAQo/v-deo.html and Part 2 - ua-cam.com/video/padKH8ys5Cs/v-deo.html
OneNote - Best Practices - ua-cam.com/video/m-4AY1cMi8s/v-deo.html
Microsoft 365 Best Practices - ua-cam.com/video/kVC_YcL5ObU/v-deo.html
Word Tables Best Practices - The ultimate guide - ua-cam.com/video/ueKCHxNUOkA/v-deo.html
Cheers. Doc.

[@kmeankunal]

Superb explanation 👌👌👌

[@efficiency365]

Thanks @kmeankunal.
Check out my other best practices videos as well.
Efficient Tasks Management - ua-cam.com/video/vLFpWVfUfQ8/v-deo.html
Microsoft Teams - 15 Best Practices - ua-cam.com/video/W8Ufx_znKxI/v-deo.html
Smart and Effective Email - 5 powerful ways - ua-cam.com/video/6NEFSMqHgQE/v-deo.html
Outlook Calendar Best Practices : Part 1 - ua-cam.com/video/GzsQnecjAQo/v-deo.html and Part 2 - ua-cam.com/video/padKH8ys5Cs/v-deo.html
OneNote - Best Practices - ua-cam.com/video/m-4AY1cMi8s/v-deo.html
Microsoft 365 Best Practices - ua-cam.com/video/kVC_YcL5ObU/v-deo.html
Word Tables Best Practices - The ultimate guide - ua-cam.com/video/ueKCHxNUOkA/v-deo.html
Cheers. Doc.

[@shwetkumar1719]

Thank You Sir🙏🙏😊😊💐💐

[@efficiency365]

Should I create interview questions type of content?

[@shwetkumar1719]

@@efficiency365 Yes sir 🙏🏻

[@efficiency365]

Ok. Will work on this.

[@electronicland7214]

Excellent solution for everyday lookus👍
Is there a way to use power query to find and show duplicates ?
For instance, table 1 shows shows person ID and name and table 2 shows person ID and order dates -
I need to build a table that will show all order dates for each person .
Thank you for your help

[@efficiency365]

Thanks @electronicland7214
Yes. This can be done. Create two queries from same data.
In one query, keep only the customer info and in other just the order info.
Customer id column should be there in each.
If you want to combine tables, use Merge Tables.
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - ua-cam.com/video/rtDlORLmjlE/v-deo.html
Excel Green Marks - Error Checking - Best Practices - ua-cam.com/video/XeLtlzd9lRY/v-deo.html
Excel Best Practices - Part 1 of 3 - Data Management - ua-cam.com/video/rr_1ha6g6lc/v-deo.html
Excel Best Practices - Part 2 of 3 - Formulas - ua-cam.com/video/kz_zAvMINAk/v-deo.html
Excel Best Practices - Part 3 of 3 - Analytics - ua-cam.com/video/JNR5yx_Pg4A/v-deo.html
10 Excel Settings You Must CHANGE! - ua-cam.com/video/vXrrXdKyJFk/v-deo.html
Automatic data clean up with Excel Flash Fill - ua-cam.com/video/N3p_x_lXT_c/v-deo.html
Instant Excel Audit, Comparison and Analysis - Inquire - ua-cam.com/video/cDdvUZxOUis/v-deo.html
Six powerful Excel Navigation Shortcuts - ua-cam.com/video/bR-yMbGPq50/v-deo.html
Handle millions of rows in Excel - Slow to fast - ua-cam.com/video/93h7rRsLF7Y/v-deo.html
Convert crosstab to tabular - Unpivot - Excel Power Query - ua-cam.com/video/mTtOtZH-nNM/v-deo.html
Cheers.
Doc