Index Match Multiple Header & Challenge Question

Index Match Multiple Header & Challenge Question
Excel Tips & Tricks Playlist Link- • Excel Tips & Tricks
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.c...
✅ Mastering Power BI Video Course
www.innozant.c...
✅ Mastering VBA Video Course
www.innozant.c...
✅ Mastering SQL Video Course
www.innozant.c...
Visit - innozant.com
=====================================================
===========HYBRID CLASSES============================
✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
✅ Database Training(SQL , PL\SQL , Oracle Developer)
✅ Mastering Data Science
Visit - innozant.com
====================================================
Videos in a Sequence -Basic to Advanced EXCEL
Basic Excel- • Basic Excel-The Learni...
Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
Excel What if Analysis- • Excel What if Analysis
Excel Array and Sumproduct- • Excel Array & Sumprodu...
Excel Lookup Functions- • Excel Lookup Functions...
Excel Pivot Tables- • Excel Pivot Tables
Excel Power Pivot- • Excel Power Pivot
Excel Power Query- • Excel Power Query
Excel Chart and Infographics- • Excel Chart and Infogr...
Excel Dashboard & Reports- • Excel Dashboard & Reports
Value add-ons Playlist
ProQuest-Check Point- • Excel ProQuest-Check P...
Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
StudsTalk -The Journey begins- • StudsTalk-The Journey ...
QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
Excel Tips and Tricks- • Excel Tips & Tricks
MIS Interview Cracker- • MIS Interview Cracker
MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
Excel Maharaj- • EXCEL MAHARAJ - For Ex...
Microsoft Powerpoint- • Microsoft Powerpoint
Microsoft Word- • Microsoft Word
Office 365- • Office 365
Google Sheets- • Google Sheets
Microsoft Outlook- • Microsoft Outlook
Power BI- • Power BI
Excel VBA- • Excel VBA Macro
TezXL Jata Shorts- • #shorts | जो TRIM के ब...
Announcements- • Announcements
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantinfotech
Facebook ► / innozantinfotech
Telegram►t.me/innozanti...
#innozant#indexmatch#indexmatchinterviewquestions #excelinterviewquestions

[@Altaf_Alam]

Sir aap excel ke king ho....aapke wajah se hi lakho bacho ko excel intersted lagne laga hai aur mujhe bhi....mai dono answer de diya hu sir video dekhne se pehle 🙏❤️😀

[@Innozant]

Great .. thanks dear

[@vishalbhati912]

U r master of all youtube teachers of excel.

[@Innozant]

Thanks Vishal ji

[@Office-Monk]

Good one. Loved the way you put the things in a very SIMPLE way

[@Innozant]

Thanks

[@createyour6681]

Very greatest video sir

[@sricharanmalik9117]

Such mein sir app ke jaisa koi nahi padhate hai thank you so much sir

[@Innozant]

Thanks Dear...Keep learning

[@ShivChoudharysingerguitarist]

Next level of Teaching, thank you so much sir.

[@Innozant]

Thanks Shiv

[@muhammadajmal6887]

Sir Gee Love your content❣️Daily viewer.

[@Innozant]

Thanks dear

[@sandeephasija8604]

Good to see your subscribers growing..
Congratulations.. 🌻

[@Innozant]

Thanks Sandeep for wishes
happy learning dear

[@shrikantbadge3978]

Amazing. So subtle

[@vasimshaikh5833]

Sir very helpful & concept clear video 🥳😍👍✌

[@Innozant]

Thanks

[@Rejuanhaque]

Very helpful video ❤ sir

[@rahulkhatri5432]

Very very useful 👏

[@MohitSinghRajput9954]

First comment & viewer and like.. ❤️

[@ashoksurin5860]

खुद ही चलना है, is heart touching word, but it's true.
Now I got Excel 20% out of 100.

[@Innozant]

Thanks..Keep exploring

[@narayanbhave3020]

Great logic Sir.

[@Innozant]

Thanks

[@kamleshprajapati3192]

You are great Sir

[@islamicstatus45698]

Thank you sir 😊

[@Innozant]

Thanks dear

[@sunilrawat8955]

Nice boss..Bhai ye jo video k end me motivational line dallte ho na ye apki video ko or effective bana deti hai.. I think ye script app k khud k he words hote hai.. Jatadhari ji ko ki c video meain dubara laye...
Thank you for your love & support thank you dill se..

[@Innozant]

Thanks dear..Koshish karta hu aap sabhi ke life me value add kar sakun

[@sunilrawat8955]

You have already done it or doing it for this world..I haven't seen any UA-cam channel which has content like yours specially of MS-Excel basic to advance level thanks to you dill se..

[@storieswithtarasharma2914]

I learnt a lot from your videos I request you to make video on lambda function because after watching many videos it's still not clear to me

[@Innozant]

Sure dear .Will make videos on lambda

[@FarhanKhan-jb2wy]

Godfather of Excel

[@Innozant]

❤️

[@niliyamtripathi9304]

Thanks for this fruitful session.
Sir please start sql video course soon!

[@Innozant]

Thanks Dear...Yes after completion of power bi and VBA series

[@bickysonkar1119]

Mast sir ji 💜

[@vijaysahal4556]

Super sir

[@Rizwan_ansari_0726]

🔥🔥🔥🔥🔥🔥

[@arjunspata1913]

Jakkkkas sir 🙏

[@ravi__negi__4333]

THANK SIR THIS QUESRTION ASKED MY IN INTEVRIEW WHERE THE HEADERS R IN DIFFERENT CELL

[@krishscout]

❤❤❤

[@aryanjangid4771]

Sir merchandise🔥

[@deepakkumarsrivastav]

Nice sir

[@bhajnlalsharma2700]

Ye kam to vookup aur concaneted formula se bhi kar sakte hai

[@Altaf_Alam]

Sir 2 no. Question mein hum jaha column no. Mangega wahi match kara lege AMPERSAND & lagakar 2 values ko year&quantity ..... Sayad ye work kare ... 🙏

[@Innozant]

❤️👍

[@Pankajpandit716]

Nice sir

[@FatihudeenFatih]

Suppose that we have the price and the brand name, and we need to find the year, I have a big data sheet where there are the revenue and the Brand Names but I have to insert the year in the next column for each price. how will you do that? please.

[@tanweerabbasabbas649]

Love from pakistan😘😘👍

[@gauravgupta6458]

❤

[@iamsainipawan]

Sir it's a humble request to you sir please start SQL structure query language series

[@Innozant]

Noted

[@iamsainipawan]

@@Innozant thanks sir for geniune reply

[@DEEPAKSINGH-es9on]

🙏

[@som8760-y7f]

Sir aap ish channel pah VBA ki series laoge kya ??
Because VBA playlist mah VBA k videos randomly uploaded h.

[@Innozant]

Random videos nhi hai in sequence playlist Bhai VBA aur power bi ke dear

[@som8760-y7f]

Sir mah aap seh bohot jaldh EXCEL, VBA & Power bi ka ofline video wali course buy karne wala hu. But sir mujhe kuch sawal h......
1)Excel mah toh every year new formulas aate h.....kya aap new changes and formulas ko apne course mah add karenga every time.
2) aapka doubt session 1-2 time/s hoti h monthly......kya mah every month participate kr sakta hu.....?

[@Innozant]

Humesha course update hote rahte hain video cours ke
Doeubt session ki koi validity nahi aap attend kar sakte hain harek month me once or twice

[@NSBrandOfficial]

Great Teacher Love From Pakistan

[@Innozant]

Thanks

[@mayursaini27]

I'm The First Liker

[@SurajKumar-w8s3m]

if my first lookup is not exact match how to solve it

[@skbisauli]

Agar year ka coulmus merge kar diya jaaye to formula kaise

[@nareshgupta8572]

आप इतनी जल्दी जल्दी बोल रहे हैं उससे कुछ समझ नहीं आ रहा है। थोड़ा धीरे धीरे हर स्टेप संजाइए तो बेहतर होगा। लोग ज्यादा इंटरेस्ट लेंगे

[@AftabAhmed-uw4ki]

Nice but i am already known index match multiple header's .problem

[@Innozant]

❤️👍

[@YKSharma9]

Solution: If I am right, in case of Index/match header row also has to be included. So, kindly chnage the range: A4:h11 -------- h4:h11.

[@Innozant]

❤️👍

[@ArvindSingh-wp8hw]

Sir, you have exchanged the row_num formula by column_num formula and column_num formula with row_num formula so getting incorrect results.

[@Innozant]

❤️👍

[@girishpadshala9689]

I do think the same mistake of exchanged array selection of rows and columns viseversa.

[@Altaf_Alam]

Sir 1st question mistake : row no. Ke place per column ko match hua hai and column no. Ke place per row match hua hai ...isiliye wrong aaraha hai 🙂

[@Innozant]

❤️👍

[@destroyer4577]

I need help

[@Innozant]

Share your query @innozantofficial telegram id

[@anushreesharma3754]

Sir I am extract data from other sheet but VALUE aa Rahi h

[@abhidas7950]

Hi Sir..I have learnt so many excel function from your video's ...but sir I have faced a situation in Excel which I failed to crack.. Situation is..
There in Column -A . obtain project code and Column -B. Shows name who work in project..now I want to move all name in column
Link ..in Col-A projectcode is "1111" and people work -"AA, BB, CC, DD" THIS IS SHOW IN ROW LEVEL..THEN HOW TO MOVE IT IN COLUMN LEVEL BESIDE THE PROJECT CODE....( IF I DO MANUALLY I USED TRANSPOSE BUT .DATA IS BIG AND IF I FOLLOW THIS PROCESS IT WILL TAKE MANY TIME...
PLEASE HELP....IF POSSIBLE..
THANK YOU IN ANTICIPATION ..

[@anilkumarparmar1784]

मेरा एक बड़ा डाटा है उसमें से मुझे सिर्फ इतना ही डाटा चाहिए जिसका वेल्यू में चाहूं उतना ही डाटा मुझे मिले

[@muhammadhuzaifa4521]

Sir apny phly wala MATCH function lagaya h wo galt h.
Q k INDEX me phly array hota h then row number then column.
SAMSUNG jo h wo ro me h jbky apny column me put kr diya h.

[@Innozant]

Very true 👍

[@anilkumarparmar1784]

उदाहरण
मेरा डाटा है उसका टोटल वेल्यू 40000 है
SrNo Supplier Name Sale
1 Malahar 1000
2 Gardian 3000
3 Safar। 12000
4 chahar 14000
5 sify techno 10000
Isme se muze sirf 18000 ka hi data chahiye to kya mil sakta hai ??

[@HarsitSharma-h8m]

गलत है भैया मै same try कर चूका हु नहीं होगा आप कोनसा version है ये plz reply 🙏

[@yogeshrao5924]

गलत है मे same try कर चुका हूँ office 365 है क्या

[@Innozant]

Office 365...it is perfectly fine

[@yogeshrao5924]

​​@@Innozantतभी गलत आया है मेरे पास 2016

[@tanweerabbasabbas649]

Boss. Nice video but you forgot to mention a very important point in second option.
IT WILL NOT WORK IF IF YOU DONT USE CNTRL SHIFT ENTER!!!🥲😘👍

[@Innozant]

Office 365- Dynamic array.,no need to press Ctrl shift enter but yes in earlier version it's mandatory 😊❤️😊