Don't Use Vlookup‼️Instead Use Amazing Function | Day 16 | Excel Learning #exceltips #shorts #excel

In this video, you will learn how to use xlookup in multiple criteria in Excel.

Join my 30 Days Excel Course: *Limited Offer*
Tap on Link to Join Course:

Benefits:
-Live Online Classes
-Get Excel Practice Sheets
-Doubt Clearing Sessions
-New Tricks and Tips
-Shortcuts
-Formulas
-Excel Templates
-Macros
-VBA Codes
-Basic to Advance Level

Join 5 Days Power BI course:

Join Telegram Channel to Get Excel Practice Sheets:

Join my Youtube Membership: Click on link below:

#exceltech #exceltips #exceltutorial #excel #exceltricks #excelhacks #excelformulas #excelfunctions #excelseries #day1excel #excellearn #learnexcel #excelforbeginners #microsoftexcel #msexcel #shortvideo #shorts #excelshorts #excelcourse #dataanalysis #analytics #dataanalytics #xlookup #vlookup

[HarryGuit]

Thanx for this new lookup. BTW criteria is plural, criterium is sg.

[robingeorge]

In this situation use sumifs. That's enough

[savvyain]

Run it for pasta small offline.. will it work for me it is showing only 1 value

[kurienillirickal]

If one criteria is a set of dates and we need to get the total for an item for a month, then how to use xlookup?

[kapilanawarathne]

Is there any formula for office version which does not have xlookup function (2016 office). ❤

[Baltie]

But it's a wrong way as it just concatenates the values. You're never sure a value comes from an expected column.

[reeganthomas]

It picked only first value not total value, 😞

[jayxpea]

When I use this it slows my computer down so bad. Its calculate threads and takes like 10-15mins to load. It’s very annoying

[punitsingla]

भाई क्या आप ispe एक वीडियो बना सकते हो ❓❓👇👇

मै excel मे gst return file बनाता हूं जिसमें पार्टी का नाम, gst nmbr, bill nmbr, total amt और cgst, sgst igst के अलग अलग colum बनाता हूं

तो मैं चाहता हूं कि मैं जब भी amount डालूँ तो GST नंबर (state wise) के hisaab से अपने आप CGST, SGST, या IGST calculate हो जाए