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

Подписаться 1,2 млн

Просмотров 351 тыс.

50% 1

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 RU-vid 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.

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

15 сен 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 329

@DeepakEduWorld 5 лет назад

🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳 *Show Me ♥ By Like Share & Comment* 🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪 *𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*

@khanhaseebGulshi 4 года назад

Bhai hme aapse bat krni h ... contact no ❤️ 79 85 07 98 53

@ExcelTricksentertainment 3 года назад

Chutiya samjhana aata nahi h

@liongaming1070 3 года назад

@@khanhaseebGulshi Computet

@liongaming1070 3 года назад

9118736807

@ms_sheikh_0143 2 года назад

So useful video sir

@avneet19kaur91 Год назад

Thank you.very helping.

@asifkhurshid9208 Год назад

great Well explained.

@amitsapoi2053 3 года назад

Very very thanks.

@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.

@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.

@govindsharma9121 2 года назад

Very nice update hai

@vikas18sharma 5 лет назад

very useful video...

@DeepakEduWorld 5 лет назад

👍

@sachingaichare4599 5 лет назад

sir aapki language bahot easy hai , I am learning excel, with the help of you. Thanks

@shipramishra9739 2 года назад

Thanks a lot sir 🙏The way you make understand is awesome 👌 whenever I feel difficulty in any topic I watch your videos.

@rejinraj7540 4 года назад

Superb and very simple explanation hence everyone could understand... Good work

@DeepakEduWorld 4 года назад

Vlookup Full Tutorial Basic to Advanced ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-V4YgQTFLmyc.html

@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👍

@arunkumarsinghark3024 Год назад

शानदार

@swastman2 4 года назад

Very nicely explained difference between Vlookup and Index. Thank you.

@NEERAJSINGH-rw6pj 6 лет назад

Very useful vedio thanks for the sharing Deepak ji

@JitenderSingh-hg8wl 2 года назад

Very informative video. Thanks.

@rohitjoshi870 2 года назад

Thank you sir. It's very helpful

@washimkhan4791 2 года назад

Verry good explanation sir...thank you.....

@sadiarizwan4819 6 лет назад

Superb Sir I like👍 your way of teaching it's simple and superior.

@shivsharma4005 6 лет назад

Great bhai thanks

@puneetsrivastava3302 4 года назад

great job. a big Salute to you. no one can teach like you.🙏🙏

@krishnaaggarwalvlogs2348 5 лет назад

Bht ache se smjhate ho ap sir.. very helpful video.. thank you

@AnilSingh-hw6sz 3 года назад

excellent brother .thanks for posting

@swethasingh9714 5 лет назад

Thanks sir

@DeepakEduWorld 5 лет назад

☺️

@mannanabdul8688 4 года назад

You explain very well. thanks Deepak. Love from pakistan

@amrishdhiman4255 3 года назад

Sir celling floor function ke upar video banaye please sir because your video is very nice 👍👍👍

@TSSACADEMY 4 года назад

good effort man

@casiddharthjain3345 6 лет назад

Very useful Keep educating Thanks

@anuthakur9726 6 лет назад

hi Deepak ji I like your. videos these are very useful thanks

@amitsheenu4270 4 года назад

Excellent explanation....

@eighttech 2 года назад

Lovely Video ❤️

@pritamranbirbanerjee5849 2 года назад

Thank you sir 😊

@mothervideo4288 2 года назад

Good

@akashhela8521 2 года назад

Excellent sir 👍👍

@mruttamagarwal 6 лет назад

Superb.

@umeshchaudhari7481 6 лет назад

Thank you sir

@kanpur.ankityadav9990 4 года назад

Supar sar

@NikitaSharma-bs4gg 2 года назад

first time i got index function

@RohitSingh-fk7nb 2 года назад

in this video u mention index match formula but u show only index dont be foul to other . very vad experience

@ritikasingh6948 2 года назад

Very nice

@khalidalisubhanallah2947 6 лет назад

Zabardast Sir G Ab Jaldi Say Index Match Function Ki Bhi Video Bana Dalain.

@rajutalwar318 6 лет назад

Thank you sir for publishing this viedo .good explanation

@mithleshsharma5561 3 года назад

good

@vikassingh8741 5 лет назад

Really appreciate your work, Index formula works very well except in case of data validation.

@C4CCoachingForCareers 4 года назад

For excel advanced video visit www.RU-vid.com/c4ccoachingforcareers

@kulaman1564 Год назад

Thx

@chetnakikan3721 3 года назад

Thanx!Thanx!

@SivaKumar-wv1zm 3 года назад

The approach to the subject is good thank you

@gyaneshmishra4 5 лет назад

Superb

@aishajabeen9380 6 лет назад

Great Video of you sir thanku so much sir ..

@abbeydudeuk 5 лет назад

best video and explanation sahi hai bhidu. keep up the good work and thank you

@anilkumarsingh4560 6 лет назад

Super Hit Video Sir

@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 6 лет назад

Ya sure.. I will publish it as soon as possible

@DeepakEduWorld 6 лет назад

👍 👍

@NaveenTamtaIamExcelVBA 4 года назад

Noor Qamar Watch my video for your answer ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ni2fU1kYIwU.html

@sankalansen8146 Месяц назад

Thank_You

@CAChandanRoy 5 лет назад

Mind blowing sir

@vasimshaikh2059 6 лет назад

Thank you

@puneetvij8433 6 лет назад

Deepak Sir, एक दम झकास | ; )

@hemantchavan4443 3 года назад

Very nice 👌👌

@hawasthi7847 6 лет назад

Bahut accha sir

@likkydevendher2417 6 лет назад

very nice sir ji

@hassanalianees5530 Год назад

Thanks

@chetan1008 2 года назад

Index formula 👍👍👍

@nirideshsorout8958 6 лет назад

Wah.. supr se bhi upr h

@jaydipsavaliya2285 6 лет назад

Nice video Sir.....thanks

@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 2 года назад

Match formula include krke best ho jayega

@nageshkumar2192 6 лет назад

Thanks sir ji

@fadishere 6 лет назад

Thank you very much bro for such a wonderful trick, anxiously waiting for next lecture

@C4CCoachingForCareers 4 года назад

For excel advanced video visit www.RU-vid.com/c4ccoachingforcareers

@kavitakanwar2161 Год назад

Sir ap mis executivve course karate Kia online

@atulkombe6508 6 лет назад

Sir please Offset Function pe vedio banao.

@Msoffice-r3q Месяц назад

Sir vlookup is better because in index, you have to apply index again and again

@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.

@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 5 лет назад

Badi table m to vlookup m b column number dene k liye columns count karna hi hoga dear..

@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 4 года назад

@@surbhibansal5429 you can use this tutorial... ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ulA2yMAeNvs.html

@niraj9896 Год назад

Bindasss,...😅🙏

@Jitenderkumar-yp1rn 4 года назад

Sir plz next video aap Choose formula ki bana do.. vlookup+choose.....🙏

@subhashdalai4316 6 лет назад

TNX SIRJI

@sanjeevgupta2286 6 лет назад

ur video is so useful i have gotten a job due to ur video

@gopalpaul3293 6 лет назад

for example..suppose lookup value hay product id jo ki 1st column may hay... to apko... =vloolup(A12,choose({1,2},$B$1:$B$6,$A$1:$A$6),2,0)

@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

@waqasmaqbool3356 2 года назад

i think vlook up vs index....vlookup strong....

@anjaneyulukodam9961 6 лет назад

Good afternoon sir,

@latikarastogi1543 6 лет назад

Great !!!

@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

@vijendrachauhan2233 6 лет назад

Deepak ji if i don't the row no. then how can i use the index fuction ?

@naveenprajapati1514 5 лет назад

agar data bohut jyada ho to index problem karega kyuki row number muskil hogi search Karne me

@rajeshsinghjadham9899 6 лет назад

thanks sirji

@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??

@Zain_ul_abideen1214 6 лет назад

bro ap bana lo yaar jaldi video INDEX+Match Function py Plz ..

@DeepakEduWorld 6 лет назад

Chk out playlist..

@soniagoyat1274 6 лет назад

deepak sir wordpad and notepad ka vedio h kya

@DeepakEduWorld 6 лет назад

Nhi

@lakksaa 6 лет назад

Sir excercise ke liye inki pdf vagera bhi available karaye

@DeepakEduWorld 6 лет назад

Ok g

@vivekm7971 3 года назад

I think index function is useless because if we have to calculate the row no. From large data...then I can look for the value manually

@avinashbarge226 6 лет назад

excuse me Sir, all the best 👍✍👍

@harshalsonawane7802 6 лет назад

नमस्ते सर, ms access के भी tutorial शुरू कीजिये सरजी

@DeepakEduWorld 6 лет назад

नमस्ते g... I will publish shortly

@harshalsonawane7802 6 лет назад

ok Thanks sir

@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??

@anonymous.1811 5 лет назад

For 10th standard students

@liongaming1070 3 года назад

💻💻💻💻💻

@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.