How To Apply INDEX and Match Formula on Large Data in Excel [Hindi]
Vložit
- čas přidán 10. 07. 2024
- How To Apply INDEX and Match Formula on Large Data in Excel [Hindi]
#excel #excelinterviewquestions #index #indexmatch
Welcome to our channel,
Practice file:
docs.google.com/spreadsheets/...
indexmatch in excel : As we all know VLOOKUP is one of the powerful function in excel, but if you are preparing for interview you must have known with INDEX and MATCH function which is mostly asked in interviews.
in this video we will cover the following:
1) Use of Index and match function
2) index and match formula on large data
3) Interview practical with index and match
Intro : 00:00
use of Index and match : 01:18
Index and match formal on large Data : 12:22
Interview practical with index and match : 15:57
Related Searches :
index formula in excel, index formula, index function in excel, how to use index function in excel, index function, match formula in excel, match function, excel formulas and functions, index match function, index and match function, index match formula, index and match formula in excel, computer gyan, index match excel, index match formula, index match function in excel,
#index_and_match
#matchfunction #excelinterviewquestions #excel_interview
#excelinterviewquestionsandanswers
Computer Gyan, You're the best! I subscribed because I love your content!
sir ur outstanding...i watch this video...now im expert in INDEX&MATCH...So THANKU SO MUCH SIR FOR SHARING YOUR KNOWLED
GE
thanks again sir very helpful video
That's too useful.🎉
Gjb h bhai sahab aap ki video |
Bahut kuch sikhane ko mila aap se
Jai shree ram
Jai Haryana Jai Bharat 🇮🇳❤
Aapka ek video 100 video ke brabar hota h🔥🔥🔥🔥🔥🔥🔥
Amazing 🤩
Sir basic to advance excel playlist banadijiye
Sir ji Ms Excel Dashboard पर विडियो बनाओ।
Sir ji Ms Excel Dashboard पर विडियो बनाओ
Excellent video sir.
thanks a lot nice helpful video
Thanks for sharing information
Lots of love from 🇳🇵
सर जी Dashboard पर विडियो बनाओ।
bhai ji ek google sheet ka master video bnaye advance level ki😊
👍🏻
Sir, Bo large data ka practice file milega ❤
There's no formula of Xlookup in my office, need solution
U required Office 2021 version.
@@Alli21 how can I get any link please?
How to find middle row data
Bro Excel ki sari short key kaise dekh sakte hai display par laptop me
Sir, apka website nahi dikha raha he google me. Ager advance excel ka playlist google ki tarha banate to acha hota sir. (Like,calss-1,calss-2 etc) Apka CZcams ka advance excel ka playlist mixed huha he sir.
Jis jis ko video achi lge wo like jaroor kre
why did u make the formula so complicated?
I think the the easiest way is =INDEX(B$2:B$27,MATCH($H$3,$A$2:$A$27,0))
please suggest
Unable to understand.
i couldn't download the excel file. that's why i give a dislike to your video.
Sir ji Ms Excel Dashboard पर विडियो बनाओ।