Тёмный

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

Computer Gyan
Подписаться 767 тыс.
Просмотров 343 тыс.
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

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 160   
@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
@royalrathore201
@royalrathore201 2 месяца назад
Lot of thanks sir bahut achi video banai hai apne
@nileshprajapati4883
@nileshprajapati4883 Месяц назад
You have given the information in a way that any level of person can understand. very good. Liked it a lot..
@geetanjalidabhade5708
@geetanjalidabhade5708 Месяц назад
Very good and helpful for every Excel user. 😊
@libmusic5268
@libmusic5268 Месяц назад
Sir, aap bohot acche se jamjhaye ho ... AJ se pahle Nehi samajh paya tha ... Thanks..
@gyanaswain146
@gyanaswain146 2 месяца назад
Brother, the way u describing every single step is unbelievable. Very easy to capture in mind and very clear to understand.
@Zahedashaikh71
@Zahedashaikh71 Месяц назад
Explanation is simple yet effective
@AnuragMishra-rw5ug
@AnuragMishra-rw5ug 2 месяца назад
बहुत अच्छा जानकारी है
@AnjaliThakur-l2007
@AnjaliThakur-l2007 2 месяца назад
Hello your information is very informative and helpful for all professionals.
@nidhishukla2832
@nidhishukla2832 Месяц назад
beautifully explained, thanks a lot
@bhargavparmar6016
@bhargavparmar6016 26 дней назад
Very Good method for teaching
@fareehahashmi230
@fareehahashmi230 20 дней назад
Well explained Thank you so much
@JPRIDERMANTU
@JPRIDERMANTU Месяц назад
Thank you sir Apki har video bohati helpful hotihe
@bhumikakocher9963
@bhumikakocher9963 Месяц назад
Really well explained
@tumitshriwas
@tumitshriwas 2 месяца назад
Bhut brya sir🎉
@fahmidamainulpushpo9004
@fahmidamainulpushpo9004 20 дней назад
Thank you so much. It was very helpful and special thanks for the practice file.
@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 18 дней назад
अगर ये सीखा देँगे तो बात बन जाये
@bajabarshaikh2097
@bajabarshaikh2097 15 дней назад
Right 😢
@jd7054
@jd7054 Месяц назад
Very nice teaching.👍👌
@surendernehra1483
@surendernehra1483 2 месяца назад
Great great 👍 👌
@togotaw2023
@togotaw2023 2 месяца назад
Superb class sir
@sourabhbajpai3003
@sourabhbajpai3003 2 дня назад
Superb
@yadavking8708
@yadavking8708 2 месяца назад
This video is very helpful sir ☺️
@SimranKaur-ye1uu
@SimranKaur-ye1uu Месяц назад
very informative
@roshansingh4643
@roshansingh4643 2 месяца назад
Thank you so much sir
@sachivtongerchakarpurya2120
@sachivtongerchakarpurya2120 Месяц назад
Best video for mis report 💯
@PoonamYadav-ut5co
@PoonamYadav-ut5co 2 месяца назад
Ameging ❤❤❤
@sunilhk2392
@sunilhk2392 Месяц назад
Ur class is too good 👍
@awesomeayush3855
@awesomeayush3855 2 месяца назад
Thanks bro
@AshwiniChavan-un4ui
@AshwiniChavan-un4ui Месяц назад
Sir khup mast shikavata
@roshansingh4643
@roshansingh4643 2 месяца назад
Very nice video
@user-bn6ly3hk2z
@user-bn6ly3hk2z 2 месяца назад
Thank you
@sibsankardas112
@sibsankardas112 Месяц назад
Nice one
@priyankagautam1682
@priyankagautam1682 2 месяца назад
Very nice sir ❤
@mitandas
@mitandas 26 дней назад
No 1 ❤
@usmannazeer8415
@usmannazeer8415 7 дней назад
Nicely Explained 😉
@silentxmoon867
@silentxmoon867 Месяц назад
thank you so much
@tokihayat2578
@tokihayat2578 2 месяца назад
Very good
@abdullahshaikhazmi5385
@abdullahshaikhazmi5385 2 месяца назад
thanks bro
@ShivamGoswami-zn2bq
@ShivamGoswami-zn2bq 2 месяца назад
Super sir
@Zamakhan-hp8yq
@Zamakhan-hp8yq 2 месяца назад
Nice ❤❤❤
@onlysmilesinu486
@onlysmilesinu486 День назад
Nice
@AbdullRaheem-in3ng
@AbdullRaheem-in3ng Месяц назад
Thanks
@mohdmoinuddin4866
@mohdmoinuddin4866 Месяц назад
your explanation is very clear and easy to understand, please continue to share your knowledge and experience with people like us
@uniqueonlinecomputergyan3988
@uniqueonlinecomputergyan3988 2 месяца назад
Really very good information😊❤❤❤❤😊😊😊❤❤😊❤😊❤😊❤😊❤😊❤😊❤😊❤😊❤😊❤😊❤😊😊❤😊❤❤😊😊❤😊❤😊😊❤😊❤😊❤😊😊❤😊 Sir me aata hu kisi din❤❤❤ Aapse milne😊😊😊
@vtechnolearning3696
@vtechnolearning3696 Месяц назад
Learn Excel Basics ru-vid.com/group/PL5qJvCApGIMcIDbSXZYOqWPsWat_PnuWR
@dipak.a.m368
@dipak.a.m368 18 дней назад
👍
@muhammadshahidfreefireplay1673
@muhammadshahidfreefireplay1673 Месяц назад
@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 ?
@prasidhiaggarwal101
@prasidhiaggarwal101 5 дней назад
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.
@vijaymax100
@vijaymax100 2 месяца назад
Very well explained brother, thanks, any link for full excel course advance level?
@yuvithefighter1264
@yuvithefighter1264 2 месяца назад
Sabse best filter use hai
@Sharmapushkar2006
@Sharmapushkar2006 2 месяца назад
Nice Sir Ek Request Hai Ki,, Expect match 0 q lete hai yh bhi bata do
@kashettibalaraju5133
@kashettibalaraju5133 Месяц назад
Nice Explain
@laxmanreddy7467
@laxmanreddy7467 Месяц назад
Efghbmkhg😂😢❤😅😊❤😂🎉😢😮😅😊
@souravsarkar4552
@souravsarkar4552 Месяц назад
Practice set mil jata toh accha hota
@MdSakib-ff1ey
@MdSakib-ff1ey Месяц назад
Very helpful video sir my all doubts clear 🎉🎉🎉
@muttakinahmed2506
@muttakinahmed2506 14 дней назад
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.
@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
@GujaratiGamer1
@GujaratiGamer1 2 месяца назад
Sir, can we put columns instead of match as you taught?
@EducatorMukesh
@EducatorMukesh 2 месяца назад
Sir excel se related workshop ki class start kijiye
@Anand-cf7br
@Anand-cf7br Месяц назад
please describe Lookup and Hlookup
@AmitBhandari-qt7vj
@AmitBhandari-qt7vj Месяц назад
Dear sir your video. It is so informative , but I want to purchase an inventory sheet please. Help to make
@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.
@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
@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
@RahulPatange-fi2sw
@RahulPatange-fi2sw Месяц назад
Ty sir subscribe🎉
@trhgaming5534
@trhgaming5534 2 месяца назад
Ager file mai date ho to ye kaam nhi kerta kya ya fir kuch aor trick ?
@subratadas1705
@subratadas1705 16 дней назад
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 🙏🏻
@itsallaboutu8300
@itsallaboutu8300 2 месяца назад
Sir agar filter laga k search krlen ?
@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 ?
@moumitabhattamondal7938
@moumitabhattamondal7938 26 дней назад
Please say slight slowly
@mumbo786
@mumbo786 25 дней назад
Pvot table me advance kuch sikhaiya na
@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?
@b4onlyme1
@b4onlyme1 2 месяца назад
What is the use of range lookup in formula?
@DeepakKumar-xh7xh
@DeepakKumar-xh7xh 25 дней назад
Filter lagane se bhi to ho sakta jaisa apne batya he.
@prakashpandey6109
@prakashpandey6109 Месяц назад
Ctrl+f se to find kar sakte hai but one by one
@VIPKFLOW
@VIPKFLOW 24 дня назад
Yeh video loom par record Hui he?
@MharisEditor00
@MharisEditor00 Месяц назад
Hello sir I need help you Picture Data convert to Excel please solution..
@samiimmu1663
@samiimmu1663 Месяц назад
Bhai Excel me v lookup ka sahi se ek bar formala batauo
@asheshbaraili473
@asheshbaraili473 9 дней назад
I used your same sheet and same exact formula but output is comming 0 can you please help me
@darshitshah6200
@darshitshah6200 2 месяца назад
Sir please provide the file in description
@somumukhopadhyay2528
@somumukhopadhyay2528 Месяц назад
I want to know power pivot table
@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
@Aaryan_Gahlot
@Aaryan_Gahlot Месяц назад
Sir Excel me job ke liye konsa formula or konsa tool aana chahiye
@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
@asiminam6085
@asiminam6085 Месяц назад
Sir yeh to filter lga kr bhi kr sakte hain
@YashMehta-xj3gv
@YashMehta-xj3gv 24 дня назад
what if header name is different in both sheet
@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!
@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
@MerryRose-lu5ig
@MerryRose-lu5ig 2 месяца назад
Sir hlookup bataye please
@shivam_vlogs-5273______
@shivam_vlogs-5273______ Месяц назад
Ji rir
@EducatorMukesh
@EducatorMukesh 2 месяца назад
Sir how to use AI in Excel
@Amitkumar-mr7qn
@Amitkumar-mr7qn 2 месяца назад
Sir yae partice file kaise download hogi ????
@ravengaming2003
@ravengaming2003 Месяц назад
Direct Filter Lagakr Search Nahi Kar Sakte kya Cntrl+L Karke Reply me
@Sonika7
@Sonika7 18 дней назад
Sir windows 7 me xlookup nahi show ho rha Wo kaise active hoga
@avijits.amusic5546
@avijits.amusic5546 2 месяца назад
Sir practice file pdf dalo Nehi group me do
@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 😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊😊
@bipinkamat4541
@bipinkamat4541 22 дня назад
Overtime Hrs. me 51 Hrs. dikhta hai par cell me click karne par 51 dikhta hai kaise please reply me
Далее
это самое вкусное блюдо
00:12
Просмотров 1,6 млн
Игровой Комп с Авито за 4500р
01:00
Вечный ДВИГАТЕЛЬ!⚙️ #shorts
00:27
Просмотров 2,1 млн
EASILY Make an Automated Data Entry Form in Excel
14:52
это самое вкусное блюдо
00:12
Просмотров 1,6 млн