How To Apply VLOOKUP and XLOOKUP Formula on Large Data in Excel [Hindi]
Вставка
- Опубліковано 29 вер 2024
- How To Apply VLOOKUP and XLOOKUP Formula on Large Data in Excel [Hindi]
#excel #excelinterviewquestions #vlookup #xlookup
Welcome to our channel,
Practice File : docs.google.co...
_______________________________________________________________________________________
😊👇⏬ Products I Use and recommend you ⏬👇😊
____________________________________________________________
1) Excel Interview Question and Answers
amzn.to/4cc3tDV
2) ASUS Vivobook 15 Laptop:
amzn.to/46wez5i
3) Sony Alpha camera for Video and Photo Shoot
amzn.to/3LMyWSa
4) Keyboard Mat for Keyboard Shortcuts
amzn.to/3yd3fhX
5) Boya wireless Mic
amzn.to/3SwkXUc
6) Boya Wired Mic
amzn.to/3yqvrhg
_____________________________________________________________________
____________________________________________________________________
vlookup in excel : vlookup is one of the powerful function of excel, use used lookup large data in excel. in this video we will understand vlookup properly.
xlookup in excel: xlookup is an advance lookup function of excel. in this video we will learn that how can you apply xlookup on large data.
watch this video and learn it easily.
Thank You.
Related Searches :
vlookup in excel, vlookup formula, vlookup in hindi, how to use vlookup in excel, vlookup function, vlookup in excel in hindi,excel formulas and functions, vlookup formula in excel, vlookup formula in excel in hindi, xlookup, xlookup formula, xlookup formula in excel, xlookup in excel, vlookup, excel, excel vlookup, ms excel, excel for beginners, xlookup function, xlookup in excel in hindi, vlookup on large data, xlookup on large data
#vlookupinexcel
#vlookup_in_excel
#how_to_apply_vlookup_in_excel
#vlookupandxlookup
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 😢
Your video works best for us God bless u
High quality video
Thanks
Very informative
what if header name is different in both sheet
Mujhe ak sheet solve kar ke doge please
filter lga k bhi to search kr lenge
Bhai filter se ho to jayega koi problem nahi but aap jara ye samjho man lo 1000 emp me koi ik I'd ko choose karana padega to wahi problem ayegi na aise simply I'd enter karege aur result prapt ho jayega
@@arfact6371 You can search emp id in filter as well
F4 key se kch ni horaa
Yes
Yes right
fn+F4 karo , then it'll work
Mashallah! 🔥Wow sir, the way You've explained!
hey bhaghwan 😢I'm not this smart.. sub mudh ke upsr se chala gaya
English ki maa behen kyu karha hai bhai
Sir mujhe samajh nhi aarha hai
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.
Find karke search kar lunga...itna lookup ki kya jaroorat
500 data ko search krke copy paste kbtk kroge 😁
Apne Jo Google drive per upload Kiya ho usko download and edit na ho raha hai ji
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😂😂
please how do I watch this in English?
Please say slight slowly
😂
I applied the same vlookup formula to identify employee id in reference with employee name but it didn't work, instead it showed me an error. Help me in rectifying this.
Sir practice file description me daal do practice kar lenge
Dal Diya hai
@@spartan5696download kaise kare nhi ho rha hai plz bta do
[4/29, 10:44 PM] manish9120kumarmaurya: O
[4/30, 8:57 AM] manish9120kumarmaurya: Bologi
@@waseemraza8196😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊 8:11 😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊
Very good and helpful for every Excel user. 😊
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 ?
MY OFFICE 2016 IS NIOT SUPPORTING XLOOKUP BUT GOOGLESHEET DOES , CAN YOU HELP/ GUIDE TO FIX THIS
Si Mera ek question hai
Ms word me mujhe bar bar name change karna hota hai ek application me to kya us format ko save kar sakte hai?
Not good but average explanation sorry but you need to improve your teaching skills or Little bit more
Super video ....please how can add my Vlookup function in excel
Sir ye sheet bnana tu seekhai phly
I have not seen someone explaining the things so crystal clear
Itne corruption hone ke bad v log firv
Modi ki guarantee bolte hain. Same on you people. Be educate. Don't be devotee of modi
When I am using VLOOKUP in sheet 2 showing 0 could you please help me
Vlookup k formula k end me 0) k badle ,)kare to bhi sahi hai kya? Uske liye wo exact value k badle false value hoga.
0 mein galat data ayenga
Aj mera interview tha supervisor ka to us MN vlookup ka pocha tha aur pivot table bhi bhi important hai
Sir excel desktops version kaise download kare
Aur Reactived kaise kare
So much excellency in your teaching, thank you very much.
Sir ek question h kya excel ka use krke freelancer me kam kr skte hain kya...please reply
VLOOKUP+MATCH KAM KARTA HAI, BUT XLOOKUP ME 2ND FILE MAI AGAR 1 COLUMN ADD OR REMOVE KARTE HAI TO RESULT NAHI MIL RAHA HAI.
FOR EXP : AGAR APKI HE KOI 1 FILE ME SE DESIGNATION KI COLUMN YA KOI BI 1 COLUMN DELETE KAR DE TO FORMULA KAM NAHI KAREGA, JO V+MATCH KARTA HAI.
PLS RELPY AND HELP
Ye saare data entry channel wale for example Roll/no 1,2,3,4,5,6 ese kses malum karna hai ek data entry wale ye nahi btya ke 5000 nbr es me ek bandee ko kese malum karna hai wo be name fe
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
Overtime Hrs. me 51 Hrs. dikhta hai par cell me click karne par 51 dikhta hai kaise please reply me
I used your same sheet and same exact formula but output is comming 0 can you please help me
One of the best lecture, very simple easy and effective
What if i want search in column changing
And also rows are also chaning
i am rady for work to the excel program in computer all offices
sir. ek question hai . main vlookup use karta hu but formula previous column me kaam nahi karta
Sir Maine interview me kiya interviewer bolta bhai ye Kya karra hai tu Maine bola sir bas tum dekho na kam wahi jo tumne Karne diye hai
can you share this excel sheet on telegram for practice purpose
Sir windows 7 me xlookup nahi show ho rha
Wo kaise active hoga
bhut he jyda confusinghai ye toh yaar kya bhasad bnaa di tune
simple bhaasa mai ni bta skta tha kya
How to get excel job in india sir...
Please make a video
Clear explanation, thank you👍🏻
After selecting the table, lock the cells using f4
agar 2 or 3 emp id ek sath dhund ne ko bola jay tab kaise hoga?
What about the Filter Add option to Search?
Practice set mil jata toh accha hota
Really very good information😊❤❤❤❤😊😊😊❤❤😊❤😊❤😊❤😊❤😊❤😊❤😊❤😊❤😊❤😊❤😊😊❤😊❤❤😊😊❤😊❤😊😊❤😊❤😊❤😊😊❤😊
Sir me aata hu kisi din❤❤❤ Aapse milne😊😊😊
Lot of thanks sir bahut achi video banai hai apne
3:35 mera result 0 Show kr raha hai name ki jagah 😢
Sir agar filter laga k search krlen ?
plz bhai youtube automation pr b video banooo
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.
Ager file mai date ho to ye kaam nhi kerta kya ya fir kuch aor trick ?
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.
V lookup and x look up kar useless .... You can just press control f and copy what you want....Only find any thing.....
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
Sir practice kaha se kare data kaha melega
Plz share your excel sheet to practice
Phir aadha gyan pura đặta feel ku n kiye
Hiii....
How to auto-populate the rate/charges of a price list when quantity is entered in?
thank you for this video. really this video is very useful.
How can I get 4 years sale at one place
Sir you are great vlookup,xlookup humko smjh hi nhi aata tha Aaj sara clear ho gya thank you so much
It’s not working in my excel
ctrl F se aur easy find karlenge🙂
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
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 👍🏻👍🏻😍❤️
What if agr seedha filter hi laga lain ?
What if agr seedha filter hi laga lain ?
What if agr seedha filter hi laga lain ?
What if agr seedha filter hi lag lain ?
I have list of entry of sales which is done everyday with voucher number and party name, description and amount. How do I short out list of perticular party only. Can it be shown on different sheet ?
Brother ❤, sab kuch too baataya,but ey srif 1/specific row mai use kar sakte hai. Lekin hum ek hee ROW(Emp name column) mai formula use karke baki sabhi ROWS Mai drag&drop karke kaise use kare?
Please Reply 🙏🏻
Love u bhai❤
aap ke video se bahut jyda help milti hai. 2:12
There is a very big wrong step goven at 3:14 where he is asking to select the entire data range .please corect it
My data lekhane ke bad kase save kare
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.
एकदम भारी.ex पण सर system report वर आपणं काम केलें आणि तो data नवीन report ला compare करायचं report खुपमोठा आहे तुम्हीं blanck sheet ऐवजी नवीन आणि काम केलेले जुने रिपोर्ट बरोबर compare करायचं असा व्हिडिओ पाहिजे होता
Most faltu vogus teacher
Hello sir I need help you Picture Data convert to Excel please solution..
please provide the access to edit before posting the video. One has to wait for your permission
Was of time school and college
Sir mai Excel pe work krta hu data bahut jada ho jata h daily ka 1000 se 1500 tk plz data correction and shorting trick
Thus guy is not even replying to questions,,poor teaching dude
Dear sir your video. It is so informative , but I want to purchase an inventory sheet please. Help to make
20 mein se 10 ka nikalna hoga toh I'd no likhne padenge phele sir ya I'd no copypaste karke likhdein matlab 10 I'd likhkar phir formula laga dein please reply karein sir
Sir Smjh nh aaya lecture, actually Sir Hum filter laga kr kesi bhe data easily se find out kr skte hen itna lamba nd complex process krne se woh behtr lag rha hy just filter aor aap jb area ko select krne se baad editing krte ho woh kis behalf per usko bhe thora detail m samjhain kion k Sb ka data yeah nh hoga hr kesi ka data apne organization k hisab se hy aor last m range wala wala section pta nh chal rha kia ho rha hy.
My query is about 1st part of lecture (Manual part) initial 4 minutes part!
beautifully explained, thanks a lot
your look awesome 🙄❤️❤️
Kindly share this file in description so we can practice this easily
Direct Filter Lagakr Search Nahi Kar Sakte kya Cntrl+L Karke Reply me
Sir ek video or banaiye jismain large data ho us main kuch data match karna ho to kaise karenge v look up se
Ex- jaise mujhe 100 contact no. Diye kisi ne us main se mere pass 30 pehle se hai no. Ab mujhy kaise pata chale ga v lookup se kon se wo 30 no. Hai jo ek baar main sab match ho jaye ..is par ek video baniye sir
Very well explained brother, thanks, any link for full excel course advance level?