Index Match Formula - Reference & Area to Lookup Answer From 3 Different Tables | Part-1 Hindi

Learn how to use the Index and Match formula with the reference and area to lookup unit price from 3 different tables with a single formula.Our Index will look for a table and within that table it look for a value that is at the intersection of row and column.
1. Match Formula
2. Index & Match 2 Way Lookup Formula
3. Index & Match Reference & Area Option to extract value from 3 different tables
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
(Playlist Folder-Excel Lookup Functions-IndexMatchReferencePart1.xlsx)
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#indexmatch #indexmatchreference #Innozant #lookup #misinterviewquestionsandanswers

[@anenlightenedmisfit6262]

I wonder why Quality channels have very less subscribers and likes.
Where teachers don't teach us even after getting paid but you are teaching us everything free of cost. Millions thanks to you Sir!!
If one subscribe can motivate you to help students in need, then this is a negligible cost for a student.
You are The Best Teacher I've ever seen in my entire life. Whole world needs teachers like you. God bless you Sir!! 👍🙏🙏

[@Innozant]

This statement really means a lot to me..
Have a wonderful career ahead ❤️

[@tanweerabbasabbas649]

😘

[@TheCSPlaybookShorts]

Love from Pakistan... Started learning from your channel, and i cant thankyou enough. Keep up the good work

[@Innozant]

Thanks Ahmed.Happy Learning ❤️❤️🙏

[@pramodparnami6012]

I also learnt Photoshop, designing from Imran, GFX MENTOR

[@vinaybhandari1449]

Ap Great Hain Sir. Humare liye ap motivation hain

[@PriyaRanjanNayak-hg4bx]

it's one of the best excel playlists I have ever come through...A ton of salute from my end...You are making typical things very easy to understand...Great job...

[@Innozant]

Thanks Priya Ranjan.. Really means a nlot to me dear

[@rajanjoshi1830]

I am greatly thankful for your tutorials. I am a non IT person, a commerce graduate. I studied your videos and successfully made my reference table in excel. Working very well. Thank you soooo much. Now i am looking for something else. I hope I get your tutorial regarding the same. !!!!☺

[@Innozant]

Thanks.For more information kindly visit innozant website

[@viswajaan]

You are my saviour. Thank you very much sir

[@shahidchanna516]

You are sea of knowledge really, your teaching way and your expressions are very help ful us to learn quickly thanks a lot sir God always bless you.

[@Innozant]

Thanks Shahid sahab
Happy Learning ❤️

[@mukulsharma9889]

Sir you are changing lives...God bless u...thank u so much to exist in this world...

[@Innozant]

Thanks Sharma ji

[@hareshchavda3890]

You have excellent knowledge of excel and batter is your teaching method... hats off...

[@Innozant]

Thanks Haresh Ji..Keep Learning ❤️

[@mominacreations381]

Very very good teacher and teaching style, i like that

[@deepalikamble3721]

Seriously sir salute hai apko,😃😃😃😃😃🧠 you are to to to intelligence

[@hridayg6446]

Well explained basics . Worth your time to understand the basics.

[@Innozant]

Thanks

[@nchander-y5i]

Quality assistance. God bless U

[@namugamer2075]

Honesty teacher .... I like your teaching way.

[@Innozant]

Thanks dear🙏❤️

[@pravinkumbhare1750]

Inspirational video and very useful... Thank you Sir..

[@raxona1]

Sir, You are genuinely a good person. God bless You..

[@Innozant]

Thanks dear

[@hassanshahzad4964]

The best way to teach. I always find index a very difficult series but now after watching your videos and then practicing ot It is super easy for me.

[@Innozant]

Thanks Hasaan ..Happy Learning 👍

[@arunrajput8693]

Sir, You tube pr or bhi log h jo excel sikhate h or kafi acha sikha lete h lekin apke samjhane ka jo tarika h na...i must say..." Aapke jaisa koi nhi"...
"Thank you Dil Se" sir...

[@Innozant]

Thanks Arun Ji.God bless You .Happy Learning ❤️

[@RajGopalPandit]

Great teaching method. Downloaded practice file and did practice. Thanks

[@ManojPal-gx6he]

Thanks sir , Really you are the greatest teacher, very .... nice training for the excel.

[@Innozant]

Thanks.Keep learning ❤️

[@ShekharKumar-yb8qe]

This channel deserve more subscribers.
Quality teaching for free, big thank to sir and team....

[@Innozant]

Thanks dear..Keep learning

[@dibyajyotisamal6043]

Best explanation of excel functions ! , Thank you sir.

[@Innozant]

Thanks

[@piyushsrivastava8375]

You are the best Excel teacher. Best wishes for your mission of educating mass.

[@Innozant]

Thanks Piyush Ji👍

[@PratikshaPatel-e5j]

This is the easiest explanation to learn index+match formula.

[@Innozant]

Thanks dear.Keep learning

[@surabhisstyle]

priceless video. ur way of explaining is totaly different from any teacher. thanks for the dedication u r showing.

[@Innozant]

Thanks dear

[@indian5653]

Thank u very much,sir.Highly recommended tutorial for every learners.

[@Innozant]

Thanks dear

[@rohit67457]

Your tutorial are such wonderful incredible everything explain in very simple language non technical person can easily understand.

[@Innozant]

Thanks Rohit.. Really means a lot to me 👍❤️

[@subhasishdey2670]

your teaching methodology is really appreciating ....

[@Innozant]

Thanks dear

[@samarahmad4784]

sir you are really awesome teacher. best teacher on youtube

[@Innozant]

Thanks Samar

[@vijayaragavanmamundi552]

Bahut kuch sikhe h...aapse
Thank u brother

[@Demon07291]

mene ye vlookup or match use kia tha,but jo nam nahi reheta usme vi num show karta,,but index wala concept ekdam sahi hi raha , jo nam nahi h usko #N/A dhikha raha,,thank you sir
or choose vi use kia tha,,multiple table k liye ye muskil tha,
=VLOOKUP(G6,CHOOSE(IF(G4="UNIT TEST",1,IF(G4="MID TEST",2,IF(G4="FINAL EXAM",3))),$A$3:$E$11,$A$15:$E$23,$A$27:$E$35),MATCH(H6,A3:E3,0))
but index se ekdam easy ho gya..
thank you sir.you are the best

[@amitapattanaik1071]

Excellent explanation, Logic ka Master mind ho aap sir.

[@Innozant]

Thanks Salil Ji .Happy Learning ❤️🙏

[@atulshukal4072]

बहोत बढीया वर्क नया देकर खुशी पाता हे धन्यवाद साहेब very good Sir

[@Innozant]

Thanks Atul ji

[@atulshukal4072]

सही सही बताया जारहा हे कमाल हे साहेब आपकी पद्धतियां और शीखाने क ढंग धन्यवाद आदरणीय महोदय

[@Innozant]

धन्यवाद अतुल जी ,उम्मीद करता हूँ आपको समझ आता है और आप सीख रहे हैं

[@AnuragSingh-w7g]

श्रीमान जी आप बेहतरीन संगणक मास्टर हो

[@cartoonloversop6019]

सर आजतक लोगो ने यही कहा है और लोगों ने भी यही सूना होगा यह आम बात है की
Experience is the Best Teacher
But Sir as you are our teacher is the Best experience for us 🙏

[@Innozant]

Thanks dear.
God Bless You.. Really means a lot to me

[@anildkumble4988]

Amazing explanation..THE BEST....Namaste ji.....Pranams

[@Innozant]

Thanks Anil ji..God bless you dear❤️🙏

[@PremSingh-ry7ek]

Explanation is very good of index match. it is clear.

[@Innozant]

Thanks Prem Ji...Happy learning

[@salilpattanayak7726]

One of the best of best tutorial critical syntax with very easy explaned. God Bless You Sir

[@Innozant]

Thanks Salil Ji...Keep learning ❤️

[@tarunrastogi9286]

apke samjhane ka tarika best hai you are doing very good for us

[@Innozant]

thanks dear

[@jaisan5582]

Hard work can be made easily if we got a Guruji like Innozant.
Pranam Guruji.

[@Innozant]

Thanks Jai..Keep learning..keep exploring ❤️

[@narottammanihal8463]

अति सुंदर , बहुत ही आसान और सरल भाषा मे समझाया आपने । इससे बेहतर चैनल मुझे नहीं लगता कोई दूसरा है ।Thank you so much Sir...

[@Innozant]

Thanks Narottam

[@akil123]

What a excellent teacher you are sir.

[@businesstruth1317]

Dhanyawad apki is video se mujhe asani se seekh liya

[@shubhankarsingh6737]

So nice of you God bless you

[@harivanshgautam3424]

Bohot he badhiya or informative video sir ji 🙏 kuch or Naya sikhne ko Mila apse.

[@Innozant]

Thanks Harivansh ji

[@golperdeshe1992]

Sir, thank you so much for providing such difficult topic in a easy way.

[@raxona1]

So nice of you. its a genuinely good content for working professionals. Thanks

[@Innozant]

Thanks dear

[@tinkuarya3777]

Good way for learning channel

[@mohammadsaifulislam6748]

What a nice presentation!!! I have never seen quality videos like these before. Many thanks for your effort, Sir.

[@Innozant]

Thanks dear..happy Learning

[@bharatvishe8753]

This is one of the best tutorial

[@vivek123440]

Clear concepts👌👍👍

[@Sanddystar17]

sar aapke saare concept no.1🙏

[@ebcy1591]

Really awesome questions related to real life problem. Thanks
Kevyan.
Jai Hind

[@Innozant]

Thanks dear

[@pavanprabhu3427]

Hi Sir, you are easily one of the best Excel teachers in India. I have learnt so much from you and your channel. This is old video and you may not see this but in case if you see, Please consider creating a video which shows which are the most important formulas needed in Excel for data analysis. Thank you

[@Innozant]

Thanks..You may watch some latest videos of channel for data analytics related queries

[@pavanprabhu3427]

@@Innozant Thank you sir! I have a aim to go through all of your videos

[@ashishjha5123]

Your teaching ability is fantastic sir, 🙏🙏

[@Vinmam1231]

From Bangalore.. Very well explained... Love you sir

[@Innozant]

👍❤️ Thanks dear

[@brajamohan4082]

power full concept .........thank you sir

[@Innozant]

Thanks Brajmohan❤️❤️

[@subhaschandramandal4430]

Very nice technique for teaching.

[@NomanAli-rl2nr]

Sir is sy phli video bhot achi lagi bhot achy sy smjhya apny❤❤ ye video abhi ni dekhi😊😅❤❤

[@KhalidMahmood-kf5zi]

Hi,
your lessons are very informative and the way of teaching is very impressive. I learnt index match formula from your vides and now applying this in my daily office work. Than you very much.
Khalid

[@Innozant]

Thats great Khalid sahab👍❤️

[@umeshpant3920]

Your videos and way of teaching is really motivated Sir. Thanks a lot...

[@Innozant]

Thanks Umesh Ji..Happy Learning ❤️

[@manjunathagangaiah6755]

It's very easy to learn MS Excel from you. I'm subscribed.

[@Innozant]

Thanks dear

[@Saurabh-Yaduvanshi.]

Logic ke Baap Hai Apne Sir

[@gajananrewale4169]

Very nice explanation sir.

[@rahul5d138]

You are Good teacher 👍👍👍👍

[@jaspalrana9541]

Thanks for making these videos.
The approach and techniques you use for teaching Excel is awesome even dull men can understand the concept.

[@Innozant]

No words.. Thanks Jaspal,M proud kii aap jaise viewer aur motivate karne waale log hain mere life me..humesha koshish karunga acha video laane ki..Even aise student jo Fees afford nhi kar skte wo padh saken.

[@razahussainansari7208]

WONDERFUL EXPLAINATION😊

[@umairzahid3743]

Sir apky smajhany ka itna khubsorat tareeqa Hai k bohat videos dhaikhi magar jis tarha ap smajhaty hain is tarha koi nhi smajhta. Jo baat ya question dimagh main aata Hai ap foren hi wo bi smajha daity hain. Sir you are only one. Beautiful sir aur jatta g ki vedios main sir apny kamal hi kr diya aisi thinking first time dhaikhi sir jahan hamari soch khatam hoti Hai wahan sy apki thinking start hoti Hai. Sir live you long life sir. Love you

[@Innozant]

Thanks Umair Zahid sahab for your valuable appreciation.. Really means a lot to me dear❤️❤️

[@Trip_with_Sandesh]

Thank you so much Sir, a very helpful class for me.. thanks for making this easy for me, really great full to you and your class.

[@Innozant]

Thanks dear..Happy learning dear

[@sandeepgusain2154]

Sir Ji bhut badiya. or bhut bhut dhanyawad.... 🤗

[@Innozant]

Aapko bhi Sandeep ji..Happy learning ❤

[@deepsingh-pc9ly]

thnak you sir aap bohat ache se samjathe hai

[@Innozant]

Thanks dear

[@AbdulHamid-no8lh]

Sir I have learn many things from your training videos.
Thanks to Allah that he give us a teacher like you

[@Innozant]

Thanks Abdul sahab

[@NS-Solution]

Sir you are really outstanding

[@crtive635]

Good great grand guide God giving

[@Tanuj-tricker]

Sir,
Your all video is valuable for everyone

[@Innozant]

Thanks Rohtash❤️🙏

[@jaiyadav1256]

Superb excellent explain great teaching

[@Innozant]

Thanks Jai

[@abidiqbal7854]

Excellent work Sir ❤❤❤❤❤

[@taharatfatima9558]

You are an awesome teacher,sir.God bless you.

[@Innozant]

Thanks dear

[@jaishrisaxena1083]

very well explained!
u are the best.

[@Innozant]

Thanks Jaishri.hv a nice day

[@shaikahmedfareed3757]

Sir you are super genius. Thanks a lot for this wonderful playlist

[@Innozant]

Thanks Shaik

[@formylove5972]

bhaiya aap jese teachers is duniya me ho toh bache bas ek hi baat boleingye *🤩🤩🫡Majja NI LIFE🥳🥳🥳🥳*
Bhout acha laga bhaiya AAp se sikh kr❤❤

[@Innozant]

Happy learning

[@rinturoy8014]

I did not know of this index-match formula before although I got to learn a lot from this video. I always use a normal index-match formula

[@devokedevtech2750]

Sir aap function achhe taraha se explain karte ho
Superb

[@Innozant]

Thanks Dheeraj,Hope aapko concept samajh aata hoga aur aap usse seekh. Rahe honge

[@REGENTREEJU-vi5vl]

very good class sir god bless u

[@ComputerclassesExpertCochingce]

Sir, I really liked your way of explaining.

[@ArunSingh-jm4jo]

Sir,. Very nicely presented and explained, I have been watching many other excel vedios but since the day I started to watch yours , no other channel is required except yours.

[@Innozant]

Thanks for giviy your love and support to Innozant Channel ♥️🙏 Aapko koi channel ab dekhne ki jrurat bhi mehsoos nhi hone denge..👍

[@shashankku.1469]

Bahut badhiya sir ji

[@Tejashwini135]

Thank you for great clarity in the concept. Thanks again

[@Innozant]

👍❤️

[@mohd.sameer3191]

Sir you are the grate teacher

[@dk17021959]

Your teaching methods is very nice. I like it very nice 👌

[@Innozant]

Thanks Dinesh Ji

[@saritadi3192]

Sir you are the best teacher

[@Innozant]

Thanks Sarita..Aapke life me yadi in videos se valuable add ho raha hai mere liye ye sabse badi kaamyabi hai

[@bishtlokesh1297]

Very helpful video for excel user and you important for us👍😍

[@MISAmber]

GREAT JOB SIR NO WORDS TO APPRECIATE

[@vikramraghuwanshi9455]

Very good explanation , sir hat's off to you.

[@Innozant]

Thanks Vikram ji

[@ExcelForBeginners.]

U r really a great teacher

[@Innozant]

Thanks Asif Sahab for such a lovely appreciation 🙏❤️🙂

[@anandbobade52]

The way you explain is amazing sir, I am a big fan of you

[@Innozant]

Thanks dear.
Keep learning ❤️

[@yogeshgosavi9325]

I have learned lot of things from you sir.

[@Innozant]

Thanks Yogesh Ji

[@laxmi-x4h]

VERY HEPLFULL FUNCTION SIR 👌

[@gopalawchar3265]

Sir...
Aap hai to kuch bhi tough nahi lagta. 🙏👏