XLOOKUP with Multiple Conditions

XLOOKUP is one of the most useful formulas in Excel, and in this video, we explore how to use it with multiple conditions. You would use an XLOOKUP with multiple conditions if you want to satisfy more than one condition, and in this case, there are two, the month and the year. If the formula finds a match for both the month and the year, it will pull the corresponding data.

The XLOOKUP function is only available in Excel 365.

I also have a video exploring a single condition XLOOKUP scenario.

#xlookup #excel #formulas #office365 #excel365 #multiple #conditions

-~-~~-~~~-~~-~-
Please watch: "Excel Top 5 Flash Fill Excel"
-~-~~-~~~-~~-~-

[jwarn]

I spent an inordinate amount of time today researching what everyone else made soooo complicated. Thanks 😊!

[zeromeansnada]

I needed to know how to do an XLOOKUP across two sheets and two conditions and watched countless videos that took forever to give the most complicated way to do XLOOKUP. I've now learned there are multiple ways to write these formulas that still follow the same general rules. The difference is you can go super complicated OR you can do it this way by Office Mystic. By far the most straight-forward explanation. A short video that gets straight to the point and easy to understand. WOW!! Thank you and Subscribed.

[GreatDataVideos]

I've looked at many videos and yours was the best by far!

[TeamHuanimal]

THANK YOU!! You saved me nearly two hours of work each week 🙌🏼🙌🏼🙌🏼🙌🏼

[wminnebo]

Very clear and concise. Great tutorial!

[percyveer]

easy to follow, short and to the point. excellent, thank you very much.

[theresa]

this saves me so much time. Thank you!

[Uvaz]

Briliant!! Very clear instructions !!👏

[LIV-FREE-VET]

That & concatenate in xlookup is a game changer. Exactly what I needed. Thank you soo much! Subscribing.

[mukundsetlur]

Awesome! I badly needed in one of my work needs, thank you very much for sharing!

[wildchildOz]

The cleanest solution that I've seen! Thanks a lot for this!

[aquayum]

Fantastic, the formula worked first time. Great, should be saving me a tonne of time at work now.

[tnex]

God bless you, being looking for this video for weeks now, hope it works on Table.

[elizabethacerra]

Such a clear video and something I really needed. At my job we use Google Sheets, and excel is very slow on my computer. This formula returns an error in sheets "Array arguments to XLOOKUP are of different size." Any idea how to fix this?

[black_south]

You are the best i was looking for this 2 days now

[juancarlospaz]

How do I have it return multiple records that meet that condition and add them up. It returns only the first record that meets the criteria, but there are more that need to be added into one. Thank you!

[lanceross]

Good video. Also really liked you you kept it short. I kept trying to nest and couldn't get it to work. I would be old and gray by the time I figured your solution out. Wait. I am already old and gray, but you know what I mean.

[AnferAlan]

I have problems with this formula, what happens if I have 2 instances of the result and I want to see them as you would do, for example if you have 2 records in June 2010, how can I visualize them, because I know that it will find it, but it will only return the value of the first one I really appreciate the hep

[orangecountyhouse]

trying to do it on Google sheets and getting error message "array argument to xlook up are of a different size".

[danielrosochacki]

Cool stuff! Thx for this, helped me a lot 😀