Video

Thanks.

Could you please explain the last parameter in the formula

hh just waw, so neat, so clean, thank you so much

Excellent!

How toclear the clipboard?

This got my ass saved as a freelance writer. I appreciate this. Subscribe if you find this helpful 🎉🎉

DUDE THIS IS THE ONLY ONE THAT WORKED. <3

You got me out of a problem; thank you!

Soooooo helpful, thanks so much!

Thanks a lot.

thank you sir

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

Have spent long hours trying to figure this out! SOOOO glad you have this video! Thanks! (BIt different on MSW 16.54 but figured it out)

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

Not all heroes wear capes.

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

Not working in my google sheet

I don't find this function in my excel version

this really help me thank you

This is NOT multiple conditioned IF statement -- this is using concatenation to combine lookup values. Misleading

Very good explanation! Did we enter the matrix 2:24?

Couldn't you have just looked up using a single data since they're in different columns? Like just using the year, or just the month? I don't really understand the use case here

I didn't know this formula even existed!

👍👍❤️

Thank you men, it worked 😊

Worked perfectly! Is there a way to have it skip cells with no data?

Finally an answer I've been looking for two days. Thank you

I have a strange situation in my excel, where I need to select the array for the lookup value, and the single value in the lookup array. I wonder why

if january and 2011 there, how to show in only one column ? thankyou

I was looking for this for quite a while. Great help!

I don't have any special menu on find and replace

Thanks mate, just what I needed!

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

thank you, this helped me removed almost all unwated blank pages

Great video, wanted to know the difference of this approach to Boolean ? I deal with large data sets snd andand and more guidance on the approach. Thanks

This is what you call it "worth it",

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.

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?

Maaannn! straight to the point.

I followed exactly your instructions, it finds the section break and when I click on remove all it does absolutely nothing. I tried deleting them manually and nothing. There must be another way.

great tutorial. Thank you!!!

Problem with this is it removes any other formatting that might already be in place.

Thank you that worked! Saved me so much time.

This video help me a lot and saved my time👍thanks

Thank you!! This was what I was looking for!

Thank you so much its done.....

Thanks!!!

THANK YOU SO MUCH!!! THESE PAGE NUMBERS WERE GIVING A HEADACHE, GLAD I NOTICED THE MESSY HEADER SECTIONS UGHHH

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

Hello, you don't have a video on the FILTER function so I am posting this question here. I have an employee leave tracker spreadsheet where I want to filter for the employees who are off a particular month. I have 2 date columns: Start Date and End Date. I have a dashboard that shows the leave booking by month. I can filter for the employees who have booked their leave for a particular month, BUT if the duration of the leave stretches to the next month or the month after I cannot show them when I change to the next month because I am filtering on the Start Date only. How can I filter so that the employee shows in all the months where they will be absent? I think I have to incorporate the End Date into it, but I have not got it to work so far.