Try This Instead of the XLOOKUP

Video quality	The size	Download

Information Try This Instead of the XLOOKUP

Title	:	Try This Instead of the XLOOKUP
Lasting	:	10.06
Date of publication	:
Views	:	145 rb

🚀 Take our Data Analyst Program here: wwwcareerprinciplescom/career-track/the-data-analyst-program
Comment from : @KenjiExplains

I just came across your videos and find them very useful and I've already learned a few new functions However, for the Fuzzy Lookup video, please review the results at time 8:26-8:45, as the results don't show Age, but another column of Sales
Comment from : @SuzLynch

😮😮😮
Comment from : @00000raunak123456789

8:26 didn't it output wrong Age? Any way to fix it?
Comment from : @jakubjanicki5931

Thanks 5:10
Comment from : @5pctLowBattery

Very cool Thanks for sharing
Comment from : @Supplychainoptimieren-yk5df

Something is wrong at 8:23 John Lee's age is 211000, as well as all the others Seems unreliable, would not use in a professional setting
Comment from : @sbioch

Nah Just fix it in the data source itself and use keys/id’s instead for looking up data Fuzzy matching will always be a boiling the frog method
Comment from : @WaldemardeHaas

why would a company hire some fuzzy employee like this?bri don't get it
Comment from : @MilMantar

unique tutorial
Comment from : @MohamedAhmed-ob2nl

Brilliant👍
Comment from : @samuelapaguntan8658

I have used match() and Index() for years , this is another option if people can't use Xlookup
Comment from : @scvrive

Using the Fuzzy Addon in the excel, the Sales and Age output seems to be same Please check that
Comment from : @rajashreedas640

Thanks so much
Comment from : @DanielFrost-w7c

I would be very cautious using this kind of function Microsoft excel is not a sound rigourous tool Maybe ok for prototyping but i would stop right here😂
Comment from : @cybu6466

as a Database developer,,, I would prohibit user to enter incorrect data ,,, at first place
Comment from : @AkbarAazra

Why didn't you just use the Soundex option in XLOOKUP?
Comment from : @thedeanman

Hoping to see the amount "1,456700" to convert word
Comment from : @ronangaming26

Bit like power BI
Comment from : @ruelvaliente7265

This is an excellent video Thank you for sharing it! brI have developed an AI assistant that supports both Google and Microsoft platforms, providing an excellent experience 🤖✨brI sincerely hope to collaborate with you I look forward to your response 😊
Comment from : @sheet-chat

Hello, is there a formulae/trick to get the xlookup formulae displaying every results it finds in the table and not only the first one? Thanks
Comment from : @sevinthomas9496

Are the power query method or fuzzy addon available in excel for mac ??
Comment from : @saiabecefg

Simple fix the data sources and manage master datano need for dodgy matching that's not working in the real world for anything important
Comment from : @how3recordings

This is very cool, thanks
Comment from : @Weehawk

Age column showing incorrect result in the 2nd method
Comment from : @dineshwagle9832

Please make a video on customer churn analysis
Comment from : @preetshah3793

The Age column is wrong
Comment from : @BadhonKarim

wow this is completely amazing video and one thing I noticed was it was some fundamentals of SQL
Comment from : @Shivakrishnan2024

Hi, please can anyone recommend any noise-cancelling software I can use during my virtuall meetings
Comment from : @stanleygadagoe3341

Thank you for such great content However , issues of accessing datasets for practice has always been a problem to me
Comment from : @godfreymusyimi9025

thank u so much
Comment from : @vishalbharakhada3357

Great video Kenji and thank you! Bummer I could not follow along because my 365 version did not suggest the number of matches after I enter threshold values 8 or 5, and on top of that, I was unable to click the OK button to proceed
Comment from : @shabchique7149

I'm an analyst and this doesn't sound like something I'd need to use all the time but is great to have in my back pocket when the need inevitably arises
Comment from : @MagicOfMushrooms

Great video!!
Comment from : @camlex6310

Does the fuzzy lookup (wither the add-in or in PQ) get the "closest option" when there are multiple matching alternatives? Or just the first one it finds on the list from top to bottom?
Comment from : @MrAszpic

I can't find fuzzy matching option in my Excel 2016 power Query
Comment from : @akinsinasegun2379

Sir i,m big fan for you🥰
Comment from : @faizujutt4942

Thanks so much, Kenji I was doing wildcards with xlookup but no matches, fuzzy lookup is thw way to go!
Comment from : @laserwebz

Excellent Kenji ❤brBut you have already tell this tip in your previous videobrWhat happened ? brWhy are you not uploading a new feature?
Comment from : @AbdulRahman-yp6oy