@@Officeinstructor Got a question, does (control shift L) to add a filter work for you in the lastest preview version? Mine is not working, and besides to add filter to the quick access bar to activate it by (alt number), are there any way to fix this?
@@Officeinstructor Got a question, does (control shift L) to add a filter work for you in the lastest preview version? Mine is not working, and besides to add filter to the quick access bar to activate it by (alt number), are there any way to fix this?
Wonderful Sktneer!! That's totally correct. However, I was trying to show that the XLOOKUP can return a Cell Reference to another function... The functionality could be used in many situations. If you get a better example for use the cell references returned by XLOOKUP, feel free to share it with me directly (info@officeinstructor.ca)... The function is new to all of us and we are trying to explore the potentials. Thanks for sharing.
@@Officeinstructor Thanks Nabil! Yes, we can explore all the possibilities where we can use XLookup or other dynamic array functions. One use I can think of is to create a named range based on XLookup and we can use it in multiple ways like as a dynamic series on a Chart. I have just emailed you one working example, let me know if you find it useful.
It is a powerful function but useless for most of the users having versions other than Office365. However, effort on the part of Mr. Nabil to produce a beautiful "Movie" is appreciable and the only reason to watch this tutorial.
A wonderful and powerful function in excel is there hope for us to have in non subscribed excel such as excel 2013,2016 or 2019 and beyond other than office 365?
Until now this function is only available in Office 365 (with Office Insider)... When they test it for a while, they will make it available to All Excel Users
5 років тому+1
@@Officeinstructor thank you for your informations
thank you Mr.. Nabil Mourad. You are an immortal Instructor .
My Followers deserve the BEST... Thank you Najib
@@Officeinstructorwelcome .
Awesome, beautiful. Thank you Nabil!
Thank you Luciano.
Thank you so much, I will be the first person to use this function in my company tomorrow, so excited!
Glad you like it
@@Officeinstructor Got a question, does (control shift L) to add a filter work for you in the lastest preview version? Mine is not working, and besides to add filter to the quick access bar to activate it by (alt number), are there any way to fix this?
@@Officeinstructor Got a question, does (control shift L) to add a filter work for you in the lastest preview version? Mine is not working, and besides to add filter to the quick access bar to activate it by (alt number), are there any way to fix this?
Excellent, thank you. You explain everything so well, I really enjoy your videos
Without the great comments and motivation from my loyal followers (like you) I couldn't have done that... Thank you Charlene
Superb
Thank you Nabil. Masterpiece !
Thank You
You could also use the following formula to sum all the amounts for a specific client...
=SUM(XLOOKUP(P2,Client,B2:M187))
Wonderful Sktneer!! That's totally correct. However, I was trying to show that the XLOOKUP can return a Cell Reference to another function... The functionality could be used in many situations. If you get a better example for use the cell references returned by XLOOKUP, feel free to share it with me directly (info@officeinstructor.ca)... The function is new to all of us and we are trying to explore the potentials. Thanks for sharing.
@@Officeinstructor Thanks Nabil! Yes, we can explore all the possibilities where we can use XLookup or other dynamic array functions. One use I can think of is to create a named range based on XLookup and we can use it in multiple ways like as a dynamic series on a Chart. I have just emailed you one working example, let me know if you find it useful.
It is a powerful function but useless for most of the users having versions other than Office365. However, effort on the part of Mr. Nabil to produce a beautiful "Movie" is appreciable and the only reason to watch this tutorial.
Awesome! Thanks sir.
Glad you liked it
Also describe different easy formulas on complex situations
Awesome subscribed
A wonderful and powerful function in excel is there hope for us to have in non subscribed excel such as excel 2013,2016 or 2019 and beyond other than office 365?
Brilliant video Nabeel. Is there a way that the table array could support 3D references
awesome
Thank you
Please don't fire VLookup. It has a family at home and kids still to put through college.
Nabil sir i was waiting for your reply if possible please let me know
Done
@@Officeinstructor Sir kindly share your email id. Want to collab with you
It's on my website
Sir I have Excel 2016 I didn't find XLOOKUP in it. Kindly guide me how could I add this function in it. Thanks.
Think its for office 356 subs only
Sorry, the functionality is ONLY AVAILABLE in Office 365 with Office Insider
This function belongs to Office 365 only?
Until now this function is only available in Office 365 (with Office Insider)... When they test it for a while, they will make it available to All Excel Users
@@Officeinstructor thank you for your informations
Nabil sir,
What about HLOOK UP ?
XLOOKUP can work Vertically or Horizontally
HLOOKUP was also fired with VLOOKUP