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
very great lecture.. bro you make it easy peasy.....but i have a question if any one know please reply this comment....according this video i learn how to use formula in row but if i want to apply in column it is not working. because i locked up values.
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.
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
एकदम भारी.ex पण सर system report वर आपणं काम केलें आणि तो data नवीन report ला compare करायचं report खुपमोठा आहे तुम्हीं blanck sheet ऐवजी नवीन आणि काम केलेले जुने रिपोर्ट बरोबर compare करायचं असा व्हिडिओ पाहिजे होता
If im not wrong, you can only search from left to right using vlookup and using xlookup u can do that. meaning , using vlookup u cant search employee name and get employee id but u can with xlookup.
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 ?
For the Match formula you made a mistake, you took the table array from the same sheet, but the table array would be the column names of "mydata" sheet. Because the column formations will not be same on different sheets as like yours.
Bro video is very nice. I have one question. Instead of 1 different sheets in same xls can we apply Vlookup using 2 different xls files? Pls reply ..becaz I have 2 different xls
That's good sir, but i have an another problem, Think "If there is a data sheet, where the goods of the same name have been entered two or three times, and I want to get the whole information of this specific goods in a single enter, then which formula should I use?"- Can you please help me to sort out.
![How To Apply INDEX and Match Formula on Large Data in Excel [Hindi] #excel](/img/1.gif)
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
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
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😂😂
Mashallah! 🔥Wow sir, the way You've explained!
Thank you sir you have explained very clear
Bahut clear tarike se explain Kiya hai ❤❤❤❤
Thanks sir job desk pe baith k aapka video dekh k just abhi abhi seekha hu dil se thanks
One of the best lecture, very simple easy and effective
Aj mera interview tha supervisor ka to us MN vlookup ka pocha tha aur pivot table bhi bhi important hai
Very detailed but crisp video. Thanks for the info !!
So much excellency in your teaching, thank you very much.
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 👍🏻👍🏻😍❤️
Must achhe se samjhate hai sir pasand aaya.❤❤❤❤❤❤
Clear explanation, thank you👍🏻
Super Explanations ( please Support VLOOKUP for large data with all Raw )
Thank you so much sir.. Ye sara skills school Mein sikhna chahiye aj ke bache bahot late ho jate hai computer Mein
Brother, the way u describing every single step is unbelievable. Very easy to capture in mind and very clear to understand.
Very clear and easy to understand, thank you
Amazingly explained. Really appreciate 👍🏻
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
Bhai jabar dast samjaya
Neatly explained
No word to explain ❤❤❤❤
Great 👍❤
Thank you so much. It was very helpful and special thanks for the practice file.
GOOD VIDEO
Very helpful video thanks bro ❤
Very good video, explained very well 😊
Sir, Very useful information. Thanks.
Ek no bhai
Very good and helpful for every Excel user. 😊
Your video works best for us God bless u
VERY HEALPFUL
your explanation is very clear and easy to understand, please continue to share your knowledge and experience with people like us
Sir you are gru of computer ❤
Bhut brya sir🎉
Very very high purity level of teaching
Thanks for this purity
very great lecture.. bro you make it easy peasy.....but i have a question if any one know please reply this comment....according this video i learn how to use formula in row but if i want to apply in column it is not working. because i locked up values.
You have given the information in a way that any level of person can understand. very good. Liked it a lot..
High quality video
Thank you so much bhaiya you saved my life 🧬
Thanks, you information
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.
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
Really very good information😊❤❤❤❤😊😊😊❤❤😊❤😊❤😊❤😊❤😊❤😊❤😊❤😊❤😊❤😊❤😊😊❤😊❤❤😊😊❤😊❤😊😊❤😊❤😊❤😊😊❤😊
Sir me aata hu kisi din❤❤❤ Aapse milne😊😊😊
Great great 👍 👌
Very nicely explained
एकदम भारी.ex पण सर system report वर आपणं काम केलें आणि तो data नवीन report ला compare करायचं report खुपमोठा आहे तुम्हीं blanck sheet ऐवजी नवीन आणि काम केलेले जुने रिपोर्ट बरोबर compare करायचं असा व्हिडिओ पाहिजे होता
Ameging ❤❤❤
Sir, aap bohot acche se jamjhaye ho ... AJ se pahle Nehi samajh paya tha ... Thanks..
Best best best❤❤❤❤
NICE
GOOD WORK
Superb class sir
Very helpful video sir my all doubts clear 🎉🎉🎉
बहुत अच्छा जानकारी है
Great 👍👍👍
Fantastic ✌️✌️👍👍👍
Thanks vlookup so seekh gaya bit xlookup ka ek integrated video banaiye
Salute sir
Thankyou very much sir ji
Dear sir your video. It is so informative , but I want to purchase an inventory sheet please. Help to make
Thanks Helpfully
thank you so much
Nicely Explained 😉
Lot of thanks sir bahut achi video banai hai apne
It helped me a lot
Wow 🎉
Super teacher❤
If im not wrong, you can only search from left to right using vlookup and using xlookup u can do that.
meaning , using vlookup u cant search employee name and get employee id but u can with xlookup.
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 ❤️ bhai
Superb
Very Good method for teaching
Nice Sir
Ek Request Hai Ki,,
Expect match 0 q lete hai yh bhi bata do
Really nice video sir
For the Match formula you made a mistake, you took the table array from the same sheet, but the table array would be the column names of "mydata" sheet. Because the column formations will not be same on different sheets as like yours.
Thanku you sir
More detailed video on xlookup , please sir 🙏
Best video for mis report 💯
Thank you Sir helpful video 🙏
Ur class is too good 👍
very useful, many thanks
Sorry to say bro but I could Press Ctrl+F & put any relevant detail of the required candidate & select the row & pull out the complete information....
Super 🎉😊
Thank you so much Bhai 😊
thank you for this video. really this video is very useful.
Dhannay ho🎉
Thank you sir
Thank you sir jii 😊
Bro video is very nice. I have one question. Instead of 1 different sheets in same xls can we apply Vlookup using 2 different xls files?
Pls reply ..becaz I have 2 different xls
Excellent bro 🔥
Thanks 👍👍👍
Super sir
very informative
too good
That's good sir, but i have an another problem, Think "If there is a data sheet, where the goods of the same name have been entered two or three times, and I want to get the whole information of this specific goods in a single enter, then which formula should I use?"- Can you please help me to sort out.
No 1 ❤
very nice