Тёмный

How To Apply VLOOKUP and XLOOKUP Formula on Large Data in Excel [Hindi]  

Computer Gyan
Подписаться 770 тыс.
Просмотров 354 тыс.
50% 1

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.com/spreadsheets/...
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

Опубликовано:

 

2 апр 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 165   
@BilalKhan-ch5gt
@BilalKhan-ch5gt 8 часов назад
Zabardast bhai khush raho ksam sa 2 din se phasa tha sab ke video faltu thi apki video zabardast 10%work❤
@vijaychattak
@vijaychattak 2 месяца назад
I have not seen someone explaining the things so crystal clear
@dkkhan5889
@dkkhan5889 2 месяца назад
Sir you are great vlookup,xlookup humko smjh hi nhi aata tha Aaj sara clear ho gya thank you so much
@DjSubolKolkataINDIA
@DjSubolKolkataINDIA 2 месяца назад
Love u bhai❤ aap ke video se bahut jyda help milti hai. 2:12
@geetanjalidabhade5708
@geetanjalidabhade5708 Месяц назад
Very good and helpful for every Excel user. 😊
@royalrathore201
@royalrathore201 2 месяца назад
Lot of thanks sir bahut achi video banai hai apne
@nileshprajapati4883
@nileshprajapati4883 2 месяца назад
You have given the information in a way that any level of person can understand. very good. Liked it a lot..
@bklaguri7645
@bklaguri7645 2 дня назад
Thank you sir jii 😊
@gyanaswain146
@gyanaswain146 2 месяца назад
Brother, the way u describing every single step is unbelievable. Very easy to capture in mind and very clear to understand.
@libmusic5268
@libmusic5268 Месяц назад
Sir, aap bohot acche se jamjhaye ho ... AJ se pahle Nehi samajh paya tha ... Thanks..
@Zahedashaikh71
@Zahedashaikh71 Месяц назад
Explanation is simple yet effective
@AnjaliThakur-l2007
@AnjaliThakur-l2007 2 месяца назад
Hello your information is very informative and helpful for all professionals.
@AnuragMishra-rw5ug
@AnuragMishra-rw5ug 2 месяца назад
बहुत अच्छा जानकारी है
@sunilnegi2764
@sunilnegi2764 День назад
Very informative
@fahmidamainulpushpo9004
@fahmidamainulpushpo9004 23 дня назад
Thank you so much. It was very helpful and special thanks for the practice file.
@nidhishukla2832
@nidhishukla2832 Месяц назад
beautifully explained, thanks a lot
@JPRIDERMANTU
@JPRIDERMANTU Месяц назад
Thank you sir Apki har video bohati helpful hotihe
@bhargavparmar6016
@bhargavparmar6016 29 дней назад
Very Good method for teaching
@fareehahashmi230
@fareehahashmi230 23 дня назад
Well explained Thank you so much
@bhumikakocher9963
@bhumikakocher9963 Месяц назад
Really well explained
@tumitshriwas
@tumitshriwas 2 месяца назад
Bhut brya sir🎉
@togotaw2023
@togotaw2023 2 месяца назад
Superb class sir
@surendernehra1483
@surendernehra1483 2 месяца назад
Great great 👍 👌
@jd7054
@jd7054 2 месяца назад
Very nice teaching.👍👌
@roshansingh4643
@roshansingh4643 2 месяца назад
Thank you so much sir
@yadavking8708
@yadavking8708 2 месяца назад
This video is very helpful sir ☺️
@sachivtongerchakarpurya2120
@sachivtongerchakarpurya2120 Месяц назад
Best video for mis report 💯
@SimranKaur-ye1uu
@SimranKaur-ye1uu Месяц назад
very informative
@mitandas
@mitandas Месяц назад
No 1 ❤
@PoonamYadav-ut5co
@PoonamYadav-ut5co 2 месяца назад
Ameging ❤❤❤
@awesomeayush3855
@awesomeayush3855 2 месяца назад
Thanks bro
@usmannazeer8415
@usmannazeer8415 10 дней назад
Nicely Explained 😉
@sunilhk2392
@sunilhk2392 Месяц назад
Ur class is too good 👍
@silentxmoon867
@silentxmoon867 Месяц назад
thank you so much
@user-bn6ly3hk2z
@user-bn6ly3hk2z 2 месяца назад
Thank you
@AshwiniChavan-un4ui
@AshwiniChavan-un4ui Месяц назад
Sir khup mast shikavata
@priyankagautam1682
@priyankagautam1682 2 месяца назад
Very nice sir ❤
@abdullahshaikhazmi5385
@abdullahshaikhazmi5385 2 месяца назад
thanks bro
@roshansingh4643
@roshansingh4643 2 месяца назад
Very nice video
@ShivamGoswami-zn2bq
@ShivamGoswami-zn2bq 2 месяца назад
Super sir
@Zamakhan-hp8yq
@Zamakhan-hp8yq 2 месяца назад
Nice ❤❤❤
@sibsankardas112
@sibsankardas112 Месяц назад
Nice one
@tokihayat2578
@tokihayat2578 2 месяца назад
Very good
@sourabhbajpai3003
@sourabhbajpai3003 6 дней назад
Superb
@mohdmoinuddin4866
@mohdmoinuddin4866 Месяц назад
your explanation is very clear and easy to understand, please continue to share your knowledge and experience with people like us
@AbdullRaheem-in3ng
@AbdullRaheem-in3ng Месяц назад
Thanks
@shiyarampandey4229
@shiyarampandey4229 Месяц назад
Yeah sub skool, college me q nhi 😢 sikhaya jata hai
@VIJAYPRAJAPATI-cn2hq
@VIJAYPRAJAPATI-cn2hq Месяц назад
Bhai school ki spelling hi galt hai😢
@IT.Technology1
@IT.Technology1 Месяц назад
School,collage walo ko khud ni ata 😂
@ankitgautam8381
@ankitgautam8381 Месяц назад
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
@pradeepkumarahirwar6619
@pradeepkumarahirwar6619 22 дня назад
अगर ये सीखा देँगे तो बात बन जाये
@bajabarshaikh2097
@bajabarshaikh2097 18 дней назад
Right 😢
@prasidhiaggarwal101
@prasidhiaggarwal101 8 дней назад
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.
@Thecomputereducation2530
@Thecomputereducation2530 2 месяца назад
Really very good information😊❤❤❤❤😊😊😊❤❤😊❤😊❤😊❤😊❤😊❤😊❤😊❤😊❤😊❤😊❤😊😊❤😊❤❤😊😊❤😊❤😊😊❤😊❤😊❤😊😊❤😊 Sir me aata hu kisi din❤❤❤ Aapse milne😊😊😊
@funtym9571
@funtym9571 Месяц назад
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 ?
@onlysmilesinu486
@onlysmilesinu486 5 дней назад
Nice
@vijaymax100
@vijaymax100 2 месяца назад
Very well explained brother, thanks, any link for full excel course advance level?
@MdSakib-ff1ey
@MdSakib-ff1ey Месяц назад
Very helpful video sir my all doubts clear 🎉🎉🎉
@muttakinahmed2506
@muttakinahmed2506 18 дней назад
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.
@Sharmapushkar2006
@Sharmapushkar2006 2 месяца назад
Nice Sir Ek Request Hai Ki,, Expect match 0 q lete hai yh bhi bata do
@yuvithefighter1264
@yuvithefighter1264 2 месяца назад
Sabse best filter use hai
@kailasjanerao3073
@kailasjanerao3073 2 месяца назад
THANK YOU SIR JI YOUR VIDEO IS REALY HELPFUL FOR PAYROLL THANK YOU SO MUCH
@souravsarkar4552
@souravsarkar4552 Месяц назад
Practice set mil jata toh accha hota
@dipak.a.m368
@dipak.a.m368 21 день назад
👍
@muhammadshahidfreefireplay1673
@muhammadshahidfreefireplay1673 Месяц назад
@kashettibalaraju5133
@kashettibalaraju5133 Месяц назад
Nice Explain
@laxmanreddy7467
@laxmanreddy7467 Месяц назад
Efghbmkhg😂😢❤😅😊❤😂🎉😢😮😅😊
@sdg8367
@sdg8367 Месяц назад
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
@Anand-cf7br
@Anand-cf7br Месяц назад
please describe Lookup and Hlookup
@GujaratiGamer1
@GujaratiGamer1 2 месяца назад
Sir, can we put columns instead of match as you taught?
@AmitBhandari-qt7vj
@AmitBhandari-qt7vj 2 месяца назад
Dear sir your video. It is so informative , but I want to purchase an inventory sheet please. Help to make
@EducatorMukesh
@EducatorMukesh 2 месяца назад
Sir excel se related workshop ki class start kijiye
@MohdAmin-mj2ni
@MohdAmin-mj2ni 2 месяца назад
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
@vtechnolearning3696
@vtechnolearning3696 Месяц назад
Learn Excel Basics ru-vid.com/group/PL5qJvCApGIMcIDbSXZYOqWPsWat_PnuWR
@user-zp2vq8dk6r
@user-zp2vq8dk6r Месяц назад
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.
@subratadas1705
@subratadas1705 19 дней назад
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 🙏🏻
@moumitabhattamondal7938
@moumitabhattamondal7938 Месяц назад
Please say slight slowly
@rizwanahmad8043
@rizwanahmad8043 2 месяца назад
Sir ek question h kya excel ka use krke freelancer me kam kr skte hain kya...please reply
@anilkumarsahoo8780
@anilkumarsahoo8780 2 месяца назад
How to get excel job in india sir... Please make a video
@RahulPatange-fi2sw
@RahulPatange-fi2sw Месяц назад
Ty sir subscribe🎉
@mumbo786
@mumbo786 28 дней назад
Pvot table me advance kuch sikhaiya na
@DeepakKumar-xh7xh
@DeepakKumar-xh7xh 28 дней назад
Filter lagane se bhi to ho sakta jaisa apne batya he.
@empirelegendyt9944
@empirelegendyt9944 День назад
What is different between VLookup and XlookUP? Because Both has Same Purpose.
@Devendraji_0007
@Devendraji_0007 2 месяца назад
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?
@umangahir9114
@umangahir9114 Месяц назад
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 ?
@trhgaming5534
@trhgaming5534 2 месяца назад
Ager file mai date ho to ye kaam nhi kerta kya ya fir kuch aor trick ?
@itsallaboutu8300
@itsallaboutu8300 2 месяца назад
Sir agar filter laga k search krlen ?
@samiimmu1663
@samiimmu1663 Месяц назад
Bhai Excel me v lookup ka sahi se ek bar formala batauo
@textileengmuetpervaizalibr7497
@textileengmuetpervaizalibr7497 2 месяца назад
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!
@b4onlyme1
@b4onlyme1 2 месяца назад
What is the use of range lookup in formula?
@prakashpandey6109
@prakashpandey6109 Месяц назад
Ctrl+f se to find kar sakte hai but one by one
@somumukhopadhyay2528
@somumukhopadhyay2528 Месяц назад
I want to know power pivot table
@darshitshah6200
@darshitshah6200 2 месяца назад
Sir please provide the file in description
@Aaryan_Gahlot
@Aaryan_Gahlot Месяц назад
Sir Excel me job ke liye konsa formula or konsa tool aana chahiye
@technicalguruimran
@technicalguruimran 2 месяца назад
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
@khushivesey8651
@khushivesey8651 2 месяца назад
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
@asheshbaraili473
@asheshbaraili473 12 дней назад
I used your same sheet and same exact formula but output is comming 0 can you please help me
@MharisEditor00
@MharisEditor00 Месяц назад
Hello sir I need help you Picture Data convert to Excel please solution..
@MerryRose-lu5ig
@MerryRose-lu5ig 2 месяца назад
Sir hlookup bataye please
@EducatorMukesh
@EducatorMukesh 2 месяца назад
Sir how to use AI in Excel
@YashMehta-xj3gv
@YashMehta-xj3gv 27 дней назад
what if header name is different in both sheet
@seoexpertramansharma2046
@seoexpertramansharma2046 2 месяца назад
Sir practice file description me daal do practice kar lenge
@spartan5696
@spartan5696 2 месяца назад
Dal Diya hai
@waseemraza8196
@waseemraza8196 2 месяца назад
​@@spartan5696download kaise kare nhi ho rha hai plz bta do
@manishmaurya5518
@manishmaurya5518 Месяц назад
[4/29, 10:44 PM] manish9120kumarmaurya: O [4/30, 8:57 AM] manish9120kumarmaurya: Bologi
@anil101177
@anil101177 Месяц назад
​@@waseemraza8196😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊 8:11 😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊
@shivam_vlogs-5273______
@shivam_vlogs-5273______ Месяц назад
Ji rir
@Itachi_Uchiha_2399
@Itachi_Uchiha_2399 Месяц назад
@computer_Gyan, what if we only need some specific data like Emp. name, attendance, designations and salary only and not the whole data. Kindly clear this Doubt please???
@Office-Monk
@Office-Monk Месяц назад
Whatever data you need, put column index number of that specific head
@asiminam6085
@asiminam6085 Месяц назад
Sir yeh to filter lga kr bhi kr sakte hain
@Amitkumar-mr7qn
@Amitkumar-mr7qn 2 месяца назад
Sir yae partice file kaise download hogi ????
Далее