Index Formula in Excel - Vlookup से भी Powerful कैसे है ये index function - देखिये | Deepak Eduworld

  Рет қаралды 351,235

Deepak EduWorld

Deepak EduWorld

Күн бұрын

Index Formula in Excel - See how to use the INDEX function to lookup something in a table based on given a row position and column position. Yes, it's true: You can look something up at the intersecting cell given a row number and a column number! Understand how to use INDEX formula, what is its syntax, how it can help you extract and analyze any data. and index is very powerful with match function. and also its very powerful than vlookup.
My New Channel : bit.ly/3qFrbl5
Complete Microsoft Word Tutorial : • How To Do Office Work ...
Complete Powerpoint Tutorial : • MS Power Point Tutoria...
Xlookup Complete Tutorial : • What Xlookup Can Do Fo...
Vlookup Complete Tutorial : bit.ly/2K0C1Sb
Excel All Formulas : • 40 most useful excel f...
Office Work in Excel : • 🤓 How To Do Office Wor...
VLOOKUP VIDEO SERIES:
1. vlookup in excel with example in Hindi
• Vlookup in Excel With ...
2. How to use vlookup for multiple values || Trick to use vlookup for large data
• सारा Data एक बार में V...
3. Vlookup in multiple sheets in excel || In Hindi
• Vlookup in multiple sh...
4. How To Use Double VLookup in Excel-Nested vlookup
• How To Use Double VLoo...
5. Dynamically Updated Vlookup Formula in Excel
• How To Make a Dynamica...
6. How To Use Vlookup With Multiple Excel Workbooks
• How To Use Vlookup in ...
7. HLOOKUP in excel with example in Hindi
• HLOOKUP in excel with ...
8. vlookup Magic 😮 Trick - Vlookup नहीं Smart Vlookup 👌 सीखो अब..
• Vlookup Magic 😮 Trick...
9. Index Formula in Excel - Vlookup से भी Powerful कैसे है ये index function - देखिये
• Index Formula in Excel...
10. How To Use Vlookup 👉 For Multiple Lookup Values In Excel
• Vlookup in Excel in Hi...
11. How To Create Picture Lookup In Excel 👉 image vlookup लगाना सीखो 😎
• How To Create Picture ...
12. Index + Match Function in Excel - Father of Vlookup || Best Ever Explanation in Hindi
• Index + Match Function...
13. Vlookup Powerful 💪 MAGIC TRICK 👉 Marge data from multiple Excel workbooks into one
• COMBINE Multiple Excel...
Subscribe and Become Family Member of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day.
Deepak EduWorld Playlist's:
POWERPOINT COURSE ►
• MS Power Point Tutoria...
ADVANCED EXCEL ►
goo.gl/A6LdZA
ADVANCED EXCEL FORMULAS ►
goo.gl/bbHYu2
EXCEL TIPS & TRICKS ►
goo.gl/wAj1jh
MS WORD ►
goo.gl/B4TeSA
HTML5 & CSS3 ►
goo.gl/2PFgs8
COMPUTER TECHNICAL videos ►
goo.gl/paZmpn
AUTOMATIC INVOICE IN EXCEL ►
goo.gl/dFhg54
PHOTOSHOP ►
• How To Make Passport S...
Subscribe Deepak EduWorld ► / deepakeduworld
Instagram ► / deepakeduworld
Facebook page ► / deepakeduworld
LinkedIn ► / deepakedu. .
Facebook Group ► / cse92
We Always Provide Useful & Helpful Content On The Deepak Eduworld KZbin Channel, Here MS Excel Tips And Tricks, And Tips And Tricks For MS Word, And Internet Tips And Tricks, Along With The Computer Related Useful Information In Simple Hindi Language. I You Can Visit Our Channel Playlist's. It Is Our Effort To Get This Information Useful For All Types Of Excel Users, MS Word Users, Computer Users And Internet Users.

Пікірлер: 329
@DeepakEduWorld
@DeepakEduWorld 5 жыл бұрын
🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳 *Show Me ♥ By Like Share & Comment* 🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪 *𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*
@khanhaseebGulshi
@khanhaseebGulshi 4 жыл бұрын
Bhai hme aapse bat krni h ... contact no ❤️ 79 85 07 98 53
@ExcelTricksentertainment
@ExcelTricksentertainment 3 жыл бұрын
Chutiya samjhana aata nahi h
@liongaming1070
@liongaming1070 3 жыл бұрын
@@khanhaseebGulshi Computet
@liongaming1070
@liongaming1070 3 жыл бұрын
9118736807
@abdulbasitbhutto6235
@abdulbasitbhutto6235 3 жыл бұрын
Hi!deepak sir.I'm from pakistani.Liked your video too much.These topic taught by our teacher wasnt clear enough,he potrayed like its diff topic but you made it too easy that im able to use it in every situation related too.
@sohailshahid7361
@sohailshahid7361 6 жыл бұрын
Hi!deepak sir.I'm from British pakistani but pakistani.Liked your video too much.These topic taught by our teacher wasnt clear enough,he potrayed like its diff topic but you made it too easy that im able to use it in every situation related too.
@rohitjoshi870
@rohitjoshi870 2 жыл бұрын
Thank you sir. It's very helpful
@psharma08612
@psharma08612 6 жыл бұрын
Bhai mene excel ke bohut video dekhe lekin kese ne b douts clear nhi kare formula kya ha nhi bataya but aap me clear tarike se bata diya. Thank u👍
@akashhela8521
@akashhela8521 2 жыл бұрын
Excellent sir 👍👍
@washimkhan4791
@washimkhan4791 3 жыл бұрын
Verry good explanation sir...thank you.....
@JitenderSingh-hg8wl
@JitenderSingh-hg8wl 2 жыл бұрын
Very informative video. Thanks.
@sachingaichare4599
@sachingaichare4599 5 жыл бұрын
sir aapki language bahot easy hai , I am learning excel, with the help of you. Thanks
@NEERAJSINGH-rw6pj
@NEERAJSINGH-rw6pj 6 жыл бұрын
Very useful vedio thanks for the sharing Deepak ji
@shipramishra9739
@shipramishra9739 2 жыл бұрын
Thanks a lot sir 🙏The way you make understand is awesome 👌 whenever I feel difficulty in any topic I watch your videos.
@amitsheenu4270
@amitsheenu4270 4 жыл бұрын
Excellent explanation....
@asifkhurshid9208
@asifkhurshid9208 Жыл бұрын
great Well explained.
@swastman2
@swastman2 4 жыл бұрын
Very nicely explained difference between Vlookup and Index. Thank you.
@rejinraj7540
@rejinraj7540 4 жыл бұрын
Superb and very simple explanation hence everyone could understand... Good work
@eighttech
@eighttech 2 жыл бұрын
Lovely Video ❤️
@avneet19kaur91
@avneet19kaur91 Жыл бұрын
Thank you.very helping.
@krishnaaggarwalvlogs2348
@krishnaaggarwalvlogs2348 5 жыл бұрын
Bht ache se smjhate ho ap sir.. very helpful video.. thank you
@ms_sheikh_0143
@ms_sheikh_0143 2 жыл бұрын
So useful video sir
@khalidalisubhanallah2947
@khalidalisubhanallah2947 6 жыл бұрын
Zabardast Sir G Ab Jaldi Say Index Match Function Ki Bhi Video Bana Dalain.
@mannanabdul8688
@mannanabdul8688 4 жыл бұрын
You explain very well. thanks Deepak. Love from pakistan
@amitsapoi2053
@amitsapoi2053 3 жыл бұрын
Very very thanks.
@sadiarizwan4819
@sadiarizwan4819 6 жыл бұрын
Superb Sir I like👍 your way of teaching it's simple and superior.
@nirideshsorout8958
@nirideshsorout8958 6 жыл бұрын
Wah.. supr se bhi upr h
@AnilSingh-hw6sz
@AnilSingh-hw6sz 3 жыл бұрын
excellent brother .thanks for posting
@puneetsrivastava3302
@puneetsrivastava3302 4 жыл бұрын
great job. a big Salute to you. no one can teach like you.🙏🙏
@casiddharthjain3345
@casiddharthjain3345 6 жыл бұрын
Very useful Keep educating Thanks
@arunkumarsinghark3024
@arunkumarsinghark3024 Жыл бұрын
शानदार
@vikas18sharma
@vikas18sharma 5 жыл бұрын
very useful video...
@DeepakEduWorld
@DeepakEduWorld 5 жыл бұрын
👍
@SivaKumar-wv1zm
@SivaKumar-wv1zm 3 жыл бұрын
The approach to the subject is good thank you
@anilkumarsingh4560
@anilkumarsingh4560 6 жыл бұрын
Super Hit Video Sir
@puneetvij8433
@puneetvij8433 6 жыл бұрын
Deepak Sir, एक दम झकास | ; )
@anuthakur9726
@anuthakur9726 6 жыл бұрын
hi Deepak ji I like your. videos these are very useful thanks
@noorqamar7580
@noorqamar7580 6 жыл бұрын
Sir I have got much respect after learnt excel from your website I have almost watched all the videos on your eduworld channel sir G thank you so much. Sir do me a favor I have to combine the contain of many workbook into a single worksheet so please publish a video illustrating easy way to do so, thanks
@DeepakEduWorld
@DeepakEduWorld 6 жыл бұрын
Ya sure.. I will publish it as soon as possible
@DeepakEduWorld
@DeepakEduWorld 6 жыл бұрын
👍 👍
@NaveenTamtaIamExcelVBA
@NaveenTamtaIamExcelVBA 4 жыл бұрын
Noor Qamar Watch my video for your answer kzbin.info/www/bejne/pJqVl4hnoL58rbc
@vikassingh8741
@vikassingh8741 5 жыл бұрын
Really appreciate your work, Index formula works very well except in case of data validation.
@C4CCoachingForCareers
@C4CCoachingForCareers 4 жыл бұрын
For excel advanced video visit www.KZbin.com/c4ccoachingforcareers
@aishajabeen9380
@aishajabeen9380 6 жыл бұрын
Great Video of you sir thanku so much sir ..
@hawasthi7847
@hawasthi7847 6 жыл бұрын
Bahut accha sir
@hemantchavan4443
@hemantchavan4443 3 жыл бұрын
Very nice 👌👌
@rajutalwar318
@rajutalwar318 6 жыл бұрын
Thank you sir for publishing this viedo .good explanation
@CAChandanRoy
@CAChandanRoy 5 жыл бұрын
Mind blowing sir
@NikitaSharma-bs4gg
@NikitaSharma-bs4gg 2 жыл бұрын
first time i got index function
@govindsharma9121
@govindsharma9121 2 жыл бұрын
Very nice update hai
@TSSACADEMY
@TSSACADEMY 4 жыл бұрын
good effort man
@likkydevendher2417
@likkydevendher2417 6 жыл бұрын
very nice sir ji
@abbeydudeuk
@abbeydudeuk 6 жыл бұрын
best video and explanation sahi hai bhidu. keep up the good work and thank you
@shivsharma4005
@shivsharma4005 6 жыл бұрын
Great bhai thanks
@RohitSingh-rs4450
@RohitSingh-rs4450 2 жыл бұрын
in this video u mention index match formula but u show only index dont be foul to other . very vad experience
@jaydipsavaliya2285
@jaydipsavaliya2285 6 жыл бұрын
Nice video Sir.....thanks
@pritamranbirbanerjee5849
@pritamranbirbanerjee5849 2 жыл бұрын
Thank you sir 😊
@mruttamagarwal
@mruttamagarwal 6 жыл бұрын
Superb.
@umeshchaudhari7481
@umeshchaudhari7481 6 жыл бұрын
Thank you sir
@fadishere
@fadishere 6 жыл бұрын
Thank you very much bro for such a wonderful trick, anxiously waiting for next lecture
@C4CCoachingForCareers
@C4CCoachingForCareers 4 жыл бұрын
For excel advanced video visit www.KZbin.com/c4ccoachingforcareers
@amrishdhiman4255
@amrishdhiman4255 3 жыл бұрын
Sir celling floor function ke upar video banaye please sir because your video is very nice 👍👍👍
@Jitenderkumar-yp1rn
@Jitenderkumar-yp1rn 4 жыл бұрын
Sir plz next video aap Choose formula ki bana do.. vlookup+choose.....🙏
@subhashdalai4316
@subhashdalai4316 6 жыл бұрын
TNX SIRJI
@sanjeevgupta2286
@sanjeevgupta2286 6 жыл бұрын
ur video is so useful i have gotten a job due to ur video
@swethasingh9714
@swethasingh9714 5 жыл бұрын
Thanks sir
@DeepakEduWorld
@DeepakEduWorld 5 жыл бұрын
☺️
@Pratibhastudychannel
@Pratibhastudychannel 3 жыл бұрын
Mtlb ye basic h abhi lekin index match function agar aa jayga use krna then agar mouse ki jgah speaker select krenge toh value automatically change ho jaygi??
@gyaneshmishra4
@gyaneshmishra4 5 жыл бұрын
Superb
@praveenchakre6099
@praveenchakre6099 6 жыл бұрын
Very nice
@chetnakikan3721
@chetnakikan3721 3 жыл бұрын
Thanx!Thanx!
@nageshkumar2192
@nageshkumar2192 6 жыл бұрын
Thanks sir ji
@atulkombe6508
@atulkombe6508 6 жыл бұрын
Sir please Offset Function pe vedio banao.
@kanpur.ankityadav9990
@kanpur.ankityadav9990 4 жыл бұрын
Supar sar
@mothervideo4288
@mothervideo4288 2 жыл бұрын
Good
@sankalansen8146
@sankalansen8146 2 ай бұрын
Thank_You
@rajeshsinghjadham9899
@rajeshsinghjadham9899 6 жыл бұрын
thanks sirji
@dharmendrayadav-bw2gp
@dharmendrayadav-bw2gp 6 жыл бұрын
Nice video sir,waiting for next videos. Sir ms access me relationship create karne ke liye table me kya similarity hony chiye mera matlab hai kise base pe hum table ko connect kartain hai. Please guid me sir.
@vasimshaikh2059
@vasimshaikh2059 6 жыл бұрын
Thank you
@latikarastogi1543
@latikarastogi1543 6 жыл бұрын
Great !!!
@anjaneyulukodam9961
@anjaneyulukodam9961 6 жыл бұрын
Good afternoon sir,
@sheikhmuhammadadnan3
@sheikhmuhammadadnan3 6 жыл бұрын
good
@kulaman1564
@kulaman1564 Жыл бұрын
Thx
@Zain_ul_abideen1214
@Zain_ul_abideen1214 6 жыл бұрын
bro ap bana lo yaar jaldi video INDEX+Match Function py Plz ..
@DeepakEduWorld
@DeepakEduWorld 6 жыл бұрын
Chk out playlist..
@DeepakEduWorld
@DeepakEduWorld 4 жыл бұрын
Vlookup Full Tutorial Basic to Advanced kzbin.info/www/bejne/jGW8mISKe7Ggr8U
@niraj9896
@niraj9896 Жыл бұрын
Bindasss,...😅🙏
@hayatullahmansoori7999
@hayatullahmansoori7999 6 жыл бұрын
Hii sir apki sabhi Vedio bahot kamal ki rahti hai sir Maine fully automatic gst invoice ready kiya hoon Usme total gst value ata hai but mujhe 18%gst and 5% gst ki value alag alag dikhani hai please help me thanks
@kavitakanwar2161
@kavitakanwar2161 Жыл бұрын
Sir ap mis executivve course karate Kia online
@ameiiravdubey9296
@ameiiravdubey9296 6 жыл бұрын
Excel ke sare formule jaise sum sum if etc inse related bi video bheje
@Anikvikram
@Anikvikram 3 жыл бұрын
Thanks
@gopalpaul3293
@gopalpaul3293 6 жыл бұрын
Deepak bhai vlookup function k sathe aap choose funtion use karo to vlookup a6e say kam karega
@DeepakEduWorld
@DeepakEduWorld 6 жыл бұрын
Ok g.. I wil publish video shortly
@chetan1008
@chetan1008 3 жыл бұрын
Index formula 👍👍👍
@ZeshanAbbasi
@ZeshanAbbasi 6 жыл бұрын
Deepak Ji. Plz Understand my problem........ Now a days main excel main Point of sale banny ki try main hu. Jis main Items ki Purchase Invoice bany, phr unhi products ko sale invoice bana kr sale kia jaye. isi trah sy agr stock return ho tu uski return invoice bany. phr in tmamam invoices ko excel date wise calculation kr ky humain stock bhi maintain kr k dy, humari total sales r expences ko bhi maintain kry r month end pr humain profit loss bhi show kry kia ya sb krna excel main possible hai ya main asy hi apna time r mind waste kr raha hu. agr ya possible hai tu kia iss p koi tutorial bana skty hain ya guide kr skty hain??
@viratsharma4794
@viratsharma4794 4 жыл бұрын
Agar isi me ek se jada ki dwtails nikalni ho to matalb ki agar vlook ki trha pure column ki details chahiye to kyaa karege
@DeepakEduWorld
@DeepakEduWorld 4 жыл бұрын
Complete vlookup tutorial kzbin.info/www/bejne/jGW8mISKe7Ggr8U
@waqasmaqbool3356
@waqasmaqbool3356 2 жыл бұрын
i think vlook up vs index....vlookup strong....
@Msoffice-r3q
@Msoffice-r3q 3 ай бұрын
Sir vlookup is better because in index, you have to apply index again and again
@vijendrachauhan2233
@vijendrachauhan2233 6 жыл бұрын
Deepak ji if i don't the row no. then how can i use the index fuction ?
@kishanmotwani134
@kishanmotwani134 6 жыл бұрын
Bhai mc office pr bhi video bnao 👌✌
@avinashbarge226
@avinashbarge226 6 жыл бұрын
excuse me Sir, all the best 👍✍👍
@surbhibansal5429
@surbhibansal5429 5 жыл бұрын
Yes sir you are right index formula is better than vlookup formula but sir hum index formula KO badi table per to use nahi Kar sakte because jyada badi table me hum exact row and column ko kaise guess kare small table me to yeh easy hai but badi table me nahi you please give me tha reason
@DeepakEduWorld
@DeepakEduWorld 5 жыл бұрын
Badi table m to vlookup m b column number dene k liye columns count karna hi hoga dear..
@surbhibansal5429
@surbhibansal5429 5 жыл бұрын
@@DeepakEduWorld but sir main apki baat se agree hu but index formula me row number calculate karna jyada difficult hai But sir I like your way to teach thankyou sir
@DataLearninghub
@DataLearninghub 4 жыл бұрын
@@surbhibansal5429 you can use this tutorial... kzbin.info/www/bejne/q52kY6yDdsqBrNU
@praveen63121
@praveen63121 6 жыл бұрын
vlook up + match ke sath bhi to ho sakta hai ye?
@amitrana8147
@amitrana8147 3 жыл бұрын
V lookup se to jada powerful hain but if we have huge amount of data firstly we have to find a lookup value row (number ) and in that case it will take too much time so vlookup choose formula is far better than this.
@Pawanhkr
@Pawanhkr 2 жыл бұрын
Match formula include krke best ho jayega
@harshalsonawane7802
@harshalsonawane7802 6 жыл бұрын
नमस्ते सर, ms access के भी tutorial शुरू कीजिये सरजी
@DeepakEduWorld
@DeepakEduWorld 6 жыл бұрын
नमस्ते g... I will publish shortly
@harshalsonawane7802
@harshalsonawane7802 6 жыл бұрын
ok Thanks sir
@lakksaa
@lakksaa 6 жыл бұрын
Sir excercise ke liye inki pdf vagera bhi available karaye
@DeepakEduWorld
@DeepakEduWorld 6 жыл бұрын
Ok g
@mohitgoswami5968
@mohitgoswami5968 6 жыл бұрын
Sir make video on SAP it will very helful because after excel SAP is demanded in corporate so please make. If other person require then please people you should also comment.
@bajratantra
@bajratantra 6 жыл бұрын
i think you should simply type or copy the value rather than using formula when you have to type row numbers to get values related to the product name , if that product is something else than mouse we have to change the formula itself
@ajmalshahtravelling7088
@ajmalshahtravelling7088 6 жыл бұрын
nice
@soniagoyat1274
@soniagoyat1274 6 жыл бұрын
deepak sir wordpad and notepad ka vedio h kya
@DeepakEduWorld
@DeepakEduWorld 6 жыл бұрын
Nhi
@mansooralam626
@mansooralam626 5 жыл бұрын
Please upload next (index and match function) vedio.
@C4CCoachingForCareers
@C4CCoachingForCareers 4 жыл бұрын
For excel advanced video visit www.KZbin.com/c4ccoachingforcareers
@ITCE2018
@ITCE2018 6 жыл бұрын
Sir plz add Match function with index function
@DeepakEduWorld
@DeepakEduWorld 6 жыл бұрын
G
小丑家的感情危机!#小丑#天使#家庭
00:15
家庭搞笑日记
Рет қаралды 33 МЛН
How to whistle ?? 😱😱
00:31
Tibo InShape
Рет қаралды 16 МЛН
Хасанның өзі эфирге шықты! “Қылмыстық топқа қатысым жоқ” дейді. Талғарда не болды? Халық сене ме?
09:25
Демократиялы Қазақстан / Демократический Казахстан
Рет қаралды 341 М.
How to Use VLOOKUP to Compare Two Lists
15:20
Simon Sez IT
Рет қаралды 842 М.
Stop using VLOOKUP in Excel. Switch to INDEX MATCH
11:05
Excel Level Up
Рет қаралды 2,4 МЛН
小丑家的感情危机!#小丑#天使#家庭
00:15
家庭搞笑日记
Рет қаралды 33 МЛН