How To Apply INDEX and Match Formula on Large Data in Excel [Hindi]
Vložit
- čas přidán 28. 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!
Excellent brother ❤
Gjb h bhai sahab aap ki video |
Bahut kuch sikhane ko mila aap se
Jai shree ram
Jai Haryana Jai Bharat 🇮🇳❤
That's too useful.🎉
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
thanks a lot nice helpful video
Ty brother plz upload more videod on excel I'm getting more interest the more im watching excel tutorial i want to become an excel expert but without your guidance it cant be possible plz sir upload one video everyday i want to learn something new everyday i watch and understand excel without laptop or computer i just watch video of yours and other and how much i understand i remember that . I was a weak student who doesn't know how to start a computer nor knows to open excel but in these 2 month of hardwork i believe i got to know muvh thing about excel i think im in love with excel !?!
Thanks for sharing information
Excellent video sir.
Sir ji Ms Excel Dashboard पर विडियो बनाओ।
Sir ji Ms Excel Dashboard पर विडियो बनाओ
Amazing 🤩
Sir basic to advance excel playlist banadijiye
Aapka ek video 100 video ke brabar hota h🔥🔥🔥🔥🔥🔥🔥
सर जी Dashboard पर विडियो बनाओ।
Lots of love from 🇳🇵
Nice one
👍🏻
bhai ji ek google sheet ka master video bnaye advance level ki😊
Bro Excel ki sari short key kaise dekh sakte hai display par laptop me
Join nhi ho pa rha hye sir. Sb kuch krne ke baad payment cancel ho ja rha hye
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.
There's no formula of Xlookup in my office, need solution
U required Office 2021 version.
@@Alli21 how can I get any link please?
You can use google sheets 😊waha par aram se use kar sqte hai x lookup 😊
Sir, Bo large data ka practice file milega ❤
How to find middle row data
TUMHARI WAJAH SE KAL
MERI CLASS MAIN BEZATI NAHI HOGI 😅
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 पर विडियो बनाओ।