Back then I was ignoring your videos thinking it's complex because of large amounts of data and examples you were using in your videos, but now I think you explain very simply and practically covering all the important aspects for new learners( you were advising us to understand the syntax of VLOOKUP) in a less amount of time. Thank you for your efforts ❤🌞.
Very informative video. But when you fix the value or range and use F4 key then you must know that it has 3 types of uses. Press F4 once = fix row and col number. Press F4 twice = fix only col Press F4 thrice = fix only row. In your example you should have fixed only the column number.
Thanks for this video, you made the things very clear I knew nothing about it but by your video i understood both VLOOKUP & XLOOKUP, did practically also. Big likee 👍🏻👍🏻😍❤️
Excellent I love the way you teach and also I see lots of video for v lookup and xlook but your explanation is marvellous 🎉 thank you so much for such a wonderful explanation
3:56"my data " to give data table from which to find out a fix name to so that automatically usi table se uthaye 5:42 to grind column no automatically using match formula 7:08 freeze using f4 8:45 xlookup
Jababrdast video bhai apka sikhane tarika bahut hi Jayda vdiya hai,main computer class lgane jata hu but itna main wha nhi sikha jitna apke channel ko dekh dekh Sikh gya hu
Sir you are great vlookup,xlookup humko smjh hi nhi aata tha Aaj sara clear ho gya thank you so much
I have not seen someone explaining the things so crystal clear
Love u bhai❤
aap ke video se bahut jyda help milti hai. 2:12
Back then I was ignoring your videos thinking it's complex because of large amounts of data and examples you were using in your videos, but now I think you explain very simply and practically covering all the important aspects for new learners( you were advising us to understand the syntax of VLOOKUP) in a less amount of time. Thank you for your efforts ❤🌞.
Behtreen yarr , me 3 sal me aj laga paya hun yeh formula... Allah tumhe iska ajar de ameen
Mashallah! 🔥Wow sir, the way You've explained!
Zabardast bhai khush raho ksam sa 2 din se phasa tha sab ke video faltu thi apki video zabardast 10%work❤
Bhai jab use karoge to pata chalega ki isme gaandu bana Diya ye ese kaam nhi karta header chenge karke dekho pata lagega😂😂
Bs 10 print bhai
Very informative video.
But when you fix the value or range and use F4 key then you must know that it has 3 types of uses.
Press F4 once = fix row and col number.
Press F4 twice = fix only col
Press F4 thrice = fix only row.
In your example you should have fixed only the column number.
Hume konsa use krna hai bcoz mera select nhi hora
MERA BI NAHI HO RAHA F4 PRESS KARAN BAD KUCH NAHI HO RAHA
Superb explanation!!💯💯
All this whole, I was not paying attention to xlookup as I was unable to understand. Your video has helped me to know the logic.
SUPER USEFUL VIDEO. THANK YOU VERY MUCH
Very super explanation 😊
One of the best lecture, very simple easy and effective
Sir ye trick bahut hi acche tarike se aap bataye ho thanks sir👍
Thanks for this video, you made the things very clear I knew nothing about it but by your video i understood both VLOOKUP & XLOOKUP, did practically also.
Big likee 👍🏻👍🏻😍❤️
Sir you are the best
Bhut brya sir🎉
Very good and helpful for every Excel user. 😊
Explained in detail...Thank you🤘
Excellent sir..
Excellent I love the way you teach and also I see lots of video for v lookup and xlook but your explanation is marvellous 🎉 thank you so much for such a wonderful explanation
Ameging ❤❤❤
Thank u soo much sr. I want learn excel from you
Must achhe se samjhate hai sir pasand aaya.❤❤❤❤❤❤
Thank you sir now' I am don't forget this formula 😊
Great learning experience 🎉❤
Bahut clear tarike se explain Kiya hai ❤❤❤❤
Great great 👍 👌
Really very good information😊❤❤❤❤😊😊😊❤❤😊❤😊❤😊❤😊❤😊❤😊❤😊❤😊❤😊❤😊❤😊😊❤😊❤❤😊😊❤😊❤😊😊❤😊❤😊❤😊😊❤😊
Sir me aata hu kisi din❤❤❤ Aapse milne😊😊😊
No word to explain ❤❤❤❤
Very informative, keep it up.
Thq so much Sir !! it was so helpful I learnt sort of things from this video!!
Kamal , lajawab ❤
Clear explanation, thank you👍🏻
Amazingly explained. Really appreciate 👍🏻
Thanks sir very informative
easy to understand
Very detailed but crisp video. Thanks for the info !!
Nice and Wonderful. Thanks...
Brother, the way u describing every single step is unbelievable. Very easy to capture in mind and very clear to understand.
Reverse lookup pr aap ek Video bnao ye.... Isi trh details me explain krte hue..... Bhoot accha❤
So much excellency in your teaching, thank you very much.
Very good video, explained very well 😊
Great 👍❤
Ya yur video is good im satisfied
Salute sir
Superb class sir
Very helpful video thanks bro ❤
Thank you sir you have explained very clear
Ek no bhai
Sir you are gru of computer ❤
Very good❤️❤️❤️❤️
Lot of thanks sir bahut achi video banai hai apne
Sir, Very useful information. Thanks.
Bhai jabar dast samjaya
thanks for helping Bro.
Thank you so much. It was very helpful and special thanks for the practice file.
ek no sir
VERY HEALPFUL
Your video works best for us God bless u
Very helpful video sir my all doubts clear 🎉🎉🎉
3:56"my data " to give data table from which to find out a fix name to so that automatically usi table se uthaye
5:42 to grind column no automatically using match formula
7:08 freeze using f4
8:45 xlookup
Fantastic ✌️✌️👍👍👍
Thanks sir 😊
Very clear and easy to understand, thank you
Best best best❤❤❤❤
GOOD VIDEO
Neatly explained
beautifully explained, thanks a lot
your look awesome 🙄❤️❤️
Very very high purity level of teaching
Thanks for this purity
Thank you so much bhaiya you saved my life 🧬
Thank you sir jii 😊
Yeah sub skool, college me q nhi 😢 sikhaya jata hai
Bhai school ki spelling hi galt hai😢
School,collage walo ko khud ni ata 😂
Sikha v diya to koi matalab nahi h kyoki job skill se nahi reference se milti hai ye to tum 1month ya 2month me seekh jaoge
अगर ये सीखा देँगे तो बात बन जाये
Right 😢
Thank you soo much sir
Super teacher❤
You have given the information in a way that any level of person can understand. very good. Liked it a lot..
Sir, aap bohot acche se jamjhaye ho ... AJ se pahle Nehi samajh paya tha ... Thanks..
Great 👍👍👍
Thank you so much sir.. Ye sara skills school Mein sikhna chahiye aj ke bache bahot late ho jate hai computer Mein
Thanks, you information
thank you for this video. really this video is very useful.
your explanation is very clear and easy to understand, please continue to share your knowledge and experience with people like us
Nice ❤❤❤
Thanks alot🙏🙏
Nicely Explained 😉
thank you so much
Excellent
Thank you ❤️ bhai
Thanks sir job desk pe baith k aapka video dekh k just abhi abhi seekha hu dil se thanks
Thank you Sir helpful video 🙏
Super 🎉😊
Jababrdast video bhai apka sikhane tarika bahut hi Jayda vdiya hai,main computer class lgane jata hu but itna main wha nhi sikha jitna apke channel ko dekh dekh Sikh gya hu
Excellent bro 🔥
Thank you ❤❤
Thanks 👍👍👍
Thank you so much Bhai 😊
बहुत अच्छा जानकारी है
School faltu ki chije padhne ko dete hai jiska koi use nahi hai school me wo chij padhani chahiye jo future me pese kamane me kam aye
Ur class is too good 👍
High quality video