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.

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)

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:

[kdotkrishna]

This is what I was looking for. This saved me from delaying the task delivery. Thank you buddy.

[IamChevalier]

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.

[HandsomeNelson]

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!!!

[Elwulven]

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!

[vishnu]

Thank you Sir, I was frantically searching for this for hours .Was able to apply this in seconds!

[vasuug]

This is what i am looking for long time. Thanks

[MillYinzMedia]

Looked everywhere on how to make this work. Brilliantly explained and executed. Thank you.

[sumsalty]

I was looking for a solution on this for HOURS, your video was exactly the solution i needed! Thank you so much!

[jackplunderbones]

Awesome! This is exactly what I needed! Thanks for posting 🙏

[imahodler]

Awesome straight to the point love your videos!!! Subscribed!

[s.m.aqeelquadri]

Great job Sir

I really appreciate your efforts and giving best understanding of xlookup.

[niranjan]

Awesome video.Helped me solve the issue i was facing like a pro. Thank you soo much

[annog]

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).

[HearthBorn]

I prefer using pipes to separate the two criteria, but yeah, this method has been around for a bit. Thanks for the reminder!

[joanarun]

Thankyou brother for this information. Now, I am able to find any information based on multiple criteria.

[francisosilo]

This is really great, it has solved my problem. Thank you so much.

[ianodonoghue]

Fantastic video. Well explained and will help me a lot in work

[rvcknoq]

Thank you so much!!! you help me a LOT!

[simoncodringtoniii]

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.

[jarilanea]

Thanks, Thanks, Thanks. You have save my day. And Thanks.