Dear Nabil, Your idea of making a video with different uses of the VLOOKUP and XLOOKUP function is very good. I really liked. However, I would like to make a contribution, just for those who have MS 365, to solve the example «ROWS and VLOOKUP Return Multiple Results?» creating the additional column in memory and not as a range. =VLOOKUP(SEQUENCE(SUM(N(D3:D36=G3))),CHOOSE({1,2,3},SCAN(0,BYROW(D3:D36,LAMBDA(a,SUM(a=G3,OFFSET(a,-1,0)))),LAMBDA(x,y,x+y)),D3:D36,E3:E36),3,0) 🤗
The background music is ONLY during the Intro and Outro of the course. Less than 2 minutes of the entire video (1:42:00). There is No music while I explain.
I felt like watching a great movie and enjoying it a lot. Great job!
A very complete tutorial Nabil. Thank you!!!!
You are most welcome my friend
Amazing tutorial. Thank you very much!!!
You're very welcome!
So complete and so clear Thks
Thanks for watching
Thank you Mr. Nabil for this efforts and thanks also to Mr. Ezzat Kiswani for share this Channel and tutorial to us
You are most welcome Tariq. If you like my tutorials, share them on your social platforms
This already done of sure 🌹🌹🌹
شكرا مستر نبيل ❤
شرفت القناة يا أستاذ أشرف
Dear Nabil,
Your idea of making a video with different uses of the VLOOKUP and XLOOKUP function is very good. I really liked.
However, I would like to make a contribution, just for those who have MS 365, to solve the example «ROWS and VLOOKUP Return Multiple Results?» creating the additional column in memory and not as a range. =VLOOKUP(SEQUENCE(SUM(N(D3:D36=G3))),CHOOSE({1,2,3},SCAN(0,BYROW(D3:D36,LAMBDA(a,SUM(a=G3,OFFSET(a,-1,0)))),LAMBDA(x,y,x+y)),D3:D36,E3:E36),3,0) 🤗
Thank you very much dear friend for watching this tutorial and for your valuable contribution
Thanks
Welcome Ali
very interesting video mr /nabil .but this back music interrupt us as Arabic country.we cant listen well
The background music is ONLY during the Intro and Outro of the course. Less than 2 minutes of the entire video (1:42:00). There is No music while I explain.
Thanks Mr., Nabeel For Amazing Work
Be Blessed !!!
Could You Please Provide Email Address ???
I am glad Izzat you found value in my tutorial.
regarding the email, we are already in contact on WhatsApp
@@Officeinstructor
Thanks A lot Dear .