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 👍🏻👍🏻😍❤️
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
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
One question, in vlookup, all the headers coloums in sheet 1 and 2 should match ? I am working in 2 sheets , where column no. Are diffrent in 2 sheets. Will this work ? What index column shall I use ?
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
The video is very helpful just have one doubt what do we have to do for vlookup multiple values at once in all the rows just by copy-pasting the formula. Column copy-pasting is clear in the video.
![Advance Filter on Large Data in Excel | Filter vs VLOOKUP | [Hindi] #excel](http://i.ytimg.com/vi/U_pj0V5EOm4/mqdefault.jpg)
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
Sir ye trick bahut hi acche tarike se aap bataye ho thanks sir👍
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
Mashallah! 🔥Wow sir, the way You've explained!
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
Kamal , lajawab ❤
Great learning experience 🎉❤
Really very good information😊❤❤❤❤😊😊😊❤❤😊❤😊❤😊❤😊❤😊❤😊❤😊❤😊❤😊❤😊❤😊😊❤😊❤❤😊😊❤😊❤😊😊❤😊❤😊❤😊😊❤😊
Sir me aata hu kisi din❤❤❤ Aapse milne😊😊😊
One of the best lecture, very simple easy and effective
Bhut brya sir🎉
Explained in detail...Thank you🤘
Must achhe se samjhate hai sir pasand aaya.❤❤❤❤❤❤
Ameging ❤❤❤
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 👍🏻👍🏻😍❤️
Very informative, keep it up.
Bahut clear tarike se explain Kiya hai ❤❤❤❤
No word to explain ❤❤❤❤
Very good and helpful for every Excel user. 😊
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
Amazingly explained. Really appreciate 👍🏻
Clear explanation, thank you👍🏻
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
Thq so much Sir !! it was so helpful I learnt sort of things from this video!!
Very detailed but crisp video. Thanks for the info !!
Reverse lookup pr aap ek Video bnao ye.... Isi trh details me explain krte hue..... Bhoot accha❤
Very good video, explained very well 😊
Ya yur video is good im satisfied
So much excellency in your teaching, thank you very much.
Best best best❤❤❤❤
Your video works best for us God bless u
Very clear and easy to understand, thank you
Very helpful video thanks bro ❤
Great great 👍 👌
Bhai jabar dast samjaya
Sir, Very useful information. Thanks.
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 sir now' I am don't forget this formula 😊
Great 👍❤
Thank you sir you have explained very clear
Lot of thanks sir bahut achi video banai hai apne
Fantastic ✌️✌️👍👍👍
Sir, aap bohot acche se jamjhaye ho ... AJ se pahle Nehi samajh paya tha ... Thanks..
beautifully explained, thanks a lot
your look awesome 🙄❤️❤️
Sir you are gru of computer ❤
thank you for this video. really this video is very useful.
Thank you soo much sir
Thank you Sir helpful video 🙏
Neatly explained
Dhannay ho🎉
Nicely Explained 😉
Thank you so much. It was very helpful and special thanks for the practice file.
Great 👍👍👍
Very very high purity level of teaching
Thanks for this purity
Excellent
Super teacher❤
you just gained a subs...
Thanks sir job desk pe baith k aapka video dekh k just abhi abhi seekha hu dil se thanks
Excellent bro 🔥
very useful, many thanks
One question, in vlookup, all the headers coloums in sheet 1 and 2 should match ?
I am working in 2 sheets , where column no. Are diffrent in 2 sheets. Will this work ? What index column shall I use ?
Thank you so much bhaiya you saved my life 🧬
Salute sir
Ur class is too good 👍
thanks for helping Bro.
Thanks alot🙏🙏
Thank you so much Bhai 😊
Thanks 👍👍👍
Thanks, you information
You have given the information in a way that any level of person can understand. very good. Liked it a lot..
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
Ek no bhai
your explanation is very clear and easy to understand, please continue to share your knowledge and experience with people like us
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
VERY HEALPFUL
Best video for mis report 💯
Brother, the way u describing every single step is unbelievable. Very easy to capture in mind and very clear to understand.
Thank you sir jii 😊
Thank you so much sir.. Ye sara skills school Mein sikhna chahiye aj ke bache bahot late ho jate hai computer Mein
Very Good method for teaching
Very nice teaching.👍👌
Super 🎉😊
Thank you ❤❤
Thankyou very much sir ji
Superb class sir
Very nicely explained
बहुत अच्छा जानकारी है
Nice ❤❤❤
Well explained
Thank you so much
Really well explained
Thank you ❤️ bhai
Explanation is simple yet effective
Wow 🎉
The video is very helpful just have one doubt what do we have to do for vlookup multiple values at once in all the rows just by copy-pasting the formula. Column copy-pasting is clear in the video.
1 week I continue watching your video s
High quality video
Very helpful video sir my all doubts clear 🎉🎉🎉
Super Explanations ( please Support VLOOKUP for large data with all Raw )
What if i want search in column changing
And also rows are also chaning