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.
![vlookup in excel | 5 Types of vlookup | excel interview questions [Hindi] #vlookup](http://i.ytimg.com/vi/KJ8jFCsZB2Y/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
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 👍🏻👍🏻😍❤️
Brother, the way u describing every single step is unbelievable. Very easy to capture in mind and very clear to understand.
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
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 ❤❤❤❤
Thank you so much. It was very helpful and special thanks for the practice file.
Great 👍❤
Very helpful video thanks bro ❤
GOOD VIDEO
Very good video, explained very well 😊
Sir, Very useful information. Thanks.
Very good and helpful for every Excel user. 😊
Ek no bhai
Your video works best for us God bless u
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 ❤
VERY HEALPFUL
Very very high purity level of teaching
Thanks for this purity
Bhut brya sir🎉
You have given the information in a way that any level of person can understand. very good. Liked it a lot..
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.
Thank you so much bhaiya you saved my life 🧬
High quality video
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
Very helpful video sir my all doubts clear 🎉🎉🎉
Superb class sir
बहुत अच्छा जानकारी है
Great 👍👍👍
Thanks vlookup so seekh gaya bit xlookup ka ek integrated video banaiye
Fantastic ✌️✌️👍👍👍
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
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.
Wow 🎉
Super teacher❤
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
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.
Really nice video sir
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 👍
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....
very useful, many thanks
Thank you so much Bhai 😊
thank you for this video. really this video is very useful.
Super 🎉😊
Thank you sir
Dhannay ho🎉
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
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.
too good
No 1 ❤
very nice