Share your opinion in the comments & if you like the video, subscribing will be much appreciated!
📺 Subscribe to receive all the latest notifications:
https://bit.ly/3aLTi9b
◀ Follow me on social media:
Twitter: https://twitter.com/mchmaitilli
Facebook: https://www.facebook.com/mecthetech
Instagram: https://www.instagram.com/mchmaitilli/
#mecthetech #xlookup #PowerQuery #excel #office365 #parameters #tipofday #productivity #worksmarternotharder #outlook #businessintelligence #automation #apparel #technology #business #management #elearning #jordan #dubai #lebanon #consulting #egypt #iraq #apple #android #unboxing #development #continuousimprovement #vision #future #mac #windows #love
XLOOKUP & the added value that it will bring
Time Stamps for the important points in the video
00:00 - Introduction
01:00 - The old VLOOKUP
01:57 - XLOOKUP - 1st CASE
02:52 - XLOOKUP - 2nd CASE
04:10 - XLOOKUP - 3rd CASE "ADVANCED"
06:50 - Closure & outro
Using Parameters will reduce your time when switching between data bases & folders on your computer
Check out my apparel, this is my store on teespring.com, I had pretty amazing merch to look at, you can support by buying any of these products
https://teespring.com/stores/mec-the-tech
Subscribe & 🔔
https://bit.ly/3aLTi9b
Check other videos in my channel
PARAMETERS ARE POWERFUL - POWERQUERY TIP
/watch/MKsNvAW6QI56N
Macbook Pro 16 Unboxing
/watch/ER9TS8sIufgIT
My Tools:
MacBook Pro
iPhone as main camera
RODE Wireless Go Mic
OM4 Gimbal
If you are interested in UNBOXING check my other channel
/channel/UC2Qo_30VFsv-SHwN1SujCrQ