XLOOKUP BIG STEP FORWARD IN OFFICE

Save
4 years ago
4

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
https://youtu.be/5IQ6WAvNsKM

Macbook Pro 16 Unboxing
https://youtu.be/gfuIs8ST9RE

My Tools:
MacBook Pro
iPhone as main camera
RODE Wireless Go Mic
OM4 Gimbal

If you are interested in UNBOXING check my other channel
https://www.youtube.com/channel/UC2Qo_30VFsv-SHwN1SujCrQ

Loading comments...