XLOOKUP BIG STEP FORWARD IN OFFICE
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
-
25:30
Stephen Gardner
19 hours ago🔴BREAKING: Trump MISTRIAL details | George Clooney's Netanyahu SECRET LEAKS!!
23.8K286 -
1:18:43
Kim Iversen
20 hours agoAmbassador Chas Freeman "Israel Has Never Put Forward A Peace Proposal"
44.7K86 -
48:34
Breaking Points
2 days agoMAGA Lawyer DEBATES Liberal Analyst On Trump Legal Cases
17.4K22 -
19:09
Scammer Payback
3 days agoConfronting Scammer Payback Imposters
73K25 -
9:07
shaneyyricch
22 hours agoAddressing my beef with Harry Sisson
55.4K96 -
1:52:46
Game On!
17 hours agoBoston Celtics Can't Win Game 2! | Sports Morning Espresso Shot
41.8K33 -
1:00:01
Trumpet Daily
1 day agoMarxist Left Continues to Imprison Trump’s Inner Circle - Trumpet Daily | June 7, 2024
38.1K56 -
LIVE
The Amber May Show
11 hours agoReAwaken America Tour Detroit, MI - DAY 2 | Join General Flynn, Eric Trump, Kash Patel, Mayor Giuliani & Team America + Request Tickets for October 18-19 Selma, NC At: TimeToFreeAmerica.com
1,513 watching -
12:23
Freakin' Reviews
1 day agoRice Robot Review: One-Touch Rice Cooker? | As Seen on TV
73.8K30 -
5:45
Game Developer
1 day agoHow To Become A Game Dev (While Working A Full Time Job)
67.4K15