XLOOKUP with Multi Criteria Lookup | How to use XLOOKUP multi criteria? [Never seen this before!!!]
XLOOKUP with Multi Criteria Lookup
You have never seen this trick before!!!
In this video we are going to see How to use XLOOKUP multi criteria? XLOOKUP function will completely replace the vlookup and hlookup also index and match function. we cover the following points in this video. Excel XLOOKUP function XLOOKUP vs VLOOKUP in excel in excel 2019 XLOOKUP in OFFICE 365 XLOOKUP in excel multiple sheets XLOOKUP multiple criteria XLOOKUP in excel with multiple criteria.
XLOOKUP using multi criteria help to get the results based two or more lookup value.
Click here to subscribe our Channel - bit.ly/2R6ar6a
Our videos are about below Microsoft Reporting Tools:
Excel Basic to Advance Pro
VBA Macro with Automation
Power BI with DAX and Dashboard
PowerPoint with various Animation
Ms-Access
Our Affordable Online Courses with Certification (Post Exam)
1. Microsoft Excel Basic, Intermediate, Advanced and Advanced Pro Level (18hrs Video Content) - bit.ly/35fmwy3
2. Microsoft Excel Advanced and Advanced Pro Level (15 Hrs Video Content) - bit.ly/3m2yxNq
3. VBA Macro Basic, Intermediate and Advanced Level (15 Hrs Content) - bit.ly/32b4A5G
4. Power Bi Basic, Intermediate and Advanced Level (15 Hrs Content) - bit.ly/2DEnRmI
Microsoft Bundle pack (Excel, VBA and Power BI) - www.digitaldcode.com/product_...
Don't hesitate to post detailed comments on a specific video and I will try to assist you as best as possible. If you find these videos useful please comment, like and share. Click on the subscribe button to join our channel and click the bell icon to get notified when new videos are released.
Let’s connect on social:
Website - www.digitaldcode.com
Facebook Page: / digitaldcode
Facebook Groups: / digitaldcode
Instagram: / digitaldcode
Twitter: / digitaldcode
LinkedIn: / digitaldcode
Пікірлер: 79
I usually never comment, but your solution is just AWESOME!!! I looked and wasted my time on different pages, and videos, and no one had this solution, which is exaclty what I was looking for! THANK YOU!!!
@DigitalDcode
2 жыл бұрын
Thank You
This is what i am looking for long time. Thanks
This is what I was looking for. This saved me from delaying the task delivery. Thank you buddy.
Thank you for the example - this is precisely what I was looking for. All the other examples were using nested XLOOKUP formulae - which constantly returned a #VALUE or other #ERR - at least in my specific model.
Awesome! This is exactly what I needed! Thanks for posting 🙏
You sir, made me do a happy dance. I had a lamda that I couldn't sync data between two tables. This fixed it so simply! Thank you!
what a life saver! thanks so much!
i got what I looking for in just 2 min. thank you!!
This is really great, it has solved my problem. Thank you so much.
Awesome straight to the point love your videos!!! Subscribed!
Thank you so much!!! you help me a LOT!
Thankyou brother for this information. Now, I am able to find any information based on multiple criteria.
very helpful. exactly what I needed.
Thank you Sir,I was frantically searching for this for hours .Was able to apply this in seconds!
@DigitalDcode
2 жыл бұрын
Thank you
If you have your Data in a Matrix format, you can just nest two xlookup functions. Just a nice trick, to get around index(match).
Thank you! This video is so helpful.
Thank you so much. This helped me!
Saved my butt, thanks!
Looked everywhere on how to make this work. Brilliantly explained and executed. Thank you.
@DigitalDcode
3 жыл бұрын
You're very welcome!
Excellent. Thank you!
Brilliant! Cheers!
Great job Sir I really appreciate your efforts and giving best understanding of xlookup.
Awesome video.Helped me solve the issue i was facing like a pro. Thank you soo much
I was looking for a solution on this for HOURS, your video was exactly the solution i needed! Thank you so much!
@DigitalDcode
2 жыл бұрын
Thank you
Great, appreciated
Amazing! Thanks, bro!
I prefer using pipes to separate the two criteria, but yeah, this method has been around for a bit. Thanks for the reminder!
Fantastic video. Well explained and will help me a lot in work
Thanks a million
AWESOME!!!!! Thanks, Thanks, Thanks. You have save my day. And Thanks.
@DigitalDcode
2 жыл бұрын
Welcome
Excellent 👌
Very helpful
THANK YOUUUUUUUU!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
THX BRO, using
This is what im looking for. Thanks bro 👍
@DigitalDcode
3 жыл бұрын
Welcome. Pls share with your friends
You are my hero! Hats off!!
@DigitalDcode
2 жыл бұрын
Thank you
Thankx
Got a question. What if I wanted to search for a value in multiple non continuous columns and return they adjacent cell. For example, look up a value in a1 and look up array in b1 to b5 and return c1 to c5 but also do the same for a second lookup array in e1 to e5 with return f1 to f5. So if value from a1 is found in b OR e it will return whats in c or f. Hope that makes sense.
life Saver !
Love you
You are the best!!!!!!
@DigitalDcode
2 жыл бұрын
Thank you
Very useful 👍
@DigitalDcode
3 жыл бұрын
Thank you
Thanks brother for helping, can I use it for words also
You are a genius
@DigitalDcode
2 жыл бұрын
Thank you
i need to lookup two coloumn, one number and other general, how can i do it?
This is so neatly explained. But I am struggling here with a model for say - in the data Angelina from Tax department has multiple managers (robin, mark, henry, martin, etc, there is no date to sort from) how can I just get a return value for say one particular manager? Can you help??
Hey.. this multiple criteria xlookup isn't working on my system (using 2021 ms office pro plus) shows #na, however, its working absolutely fine on web excel. Any idea whats the issue?
@DigitalDcode
2 жыл бұрын
It should work. Not sure on the issue
Please teach us more conditional formatting for xlookups
I have excel sheet , price according to number of persons , would like to get the price for the service I choose when i add how many persons I have
What if I have two lookup values, and lookup array in four column, how we will apply formula ?
Instead of selecting the column range and fixed it (e.g. $B$4:$B$25), what's the downside of just using the whole column B?
Thanks a lot as this is a game changer! However, i wanted to check if this function makes excel slower? i used it on a file where i dragged the same formula on more than 600 rows and after that the file became very slow... even when i filter it takes time.
@DigitalDcode
2 жыл бұрын
I never faced such issue. But you can select cells or column which has only data
@abeximt
2 жыл бұрын
@@DigitalDcode i noticed my file size jumped to 7MB... it is probably cause i am applying the formula on an excel table
why do u freeze it?
If the data has about twenty thousand rows, which function has the fastest processing speed and returns the fastest results? Xlookup or sql or another ...?
@DigitalDcode
3 жыл бұрын
XLOOKUP
Hii add in this formula Sumifs
Even after typing the same formula in multiple criteria, # N/A is coming… What is the reason?
I cannot make this work and I have no idea why. if anyone is able to help, please let me know
what if one of the criteria is horizontal and two vertical.
@DigitalDcode
2 жыл бұрын
The same solution should work
@ishaq79
2 жыл бұрын
@@DigitalDcode it didn't work so i used sumproduct
He keeps saying "freeze it"? when he adds the wildcards. How is he doing that?
@jenniferg1747
8 ай бұрын
Click F4- it freezes a cell location by adding $ to the column and row location
is this file downloadable
@DigitalDcode
Жыл бұрын
No
Would be nice if there is no noise of keyboard buttons