Index & Match Functions- Excel Three Way Lookup using Index & Match & Conditional Formatting

Index & Match Functions- Excel Three Way Lookup using Index & Match & Conditional Formatting
1. Learn how to use three way lookup using index & match
2. Conditional formatting & index match for three way lookup
3. Example & explanation how to apply three way lookup in excel & conditional formatting
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.com/drive/folder...
(Playlist Folder-Excel Lookup Functions-ThreeWayLookup.xlsx)
Direct Link-drive.google.com/file/d/1bNlV...
Note: In Conditional Formatting Example kindly select cell A6 instead of A5,minor selection mistake are there in video,kindly rectify it while doing practice for the same.
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#threewaylookup #indexmatchinexcel#Innozant #misinterviewquestions

[@umairzahid3743]

Respected Sir, your way of learning is really amazing. By God you are the only Hon'l teacher who are learning very deeply. Sir didn't leave any point which is raised in my mind. Sir in this world, only found some people, who have sensitive heart for others. And it is highly appreciated for the practice folder make for us for better learning. Sir amazing. Live Long Life Sir.

[@Innozant]

Thanks for your valuable appreciation .God bless you dear❤️

[@abhishektiwari2643]

@@Innozant sir esme jo conditional formatting laga hai vo to jo ham lookup value me diye hai vo usase ek row niche se color kar raha hai
Sir use ek bar check kijiye

[@123barana]

Excellent way of teaching ,You have In-depth knowledge of concept

[@shrikantbadge3978]

I am speechless. Hats off. Watched. Tried myself. Now got it fixed in my mind. Thanks.

[@Innozant]

Thanks Shrikant,One way two way and three way lookup tips par hona chaiye aapke.❤️🙏😊

[@RajGopalPandit]

completed ali the three steps of conditional formating. Amazing trick. Thanks

[@RakeshSingh-qo5nd]

Sir mai janta hu comment ki length thodi lambi ho gyi hai but aap jo kaam kar rhe ho use sirf 1 ya 2 word likh kar (Amazing sir, Nice video) justify nhi kiya jaa skta... Mai apka playlist dekh rha tha start se to mujhe realise hua ki aap to bilkul coaching class kya tarah padha rhe ho start se aur hme ye sochne ki jarurat bhi nhi hai kaun sa video pahle padhe aur kaun sa baad me... Agar aap Noida ya delhi me rahte hoge to shayad MAATI Institute (Noorain Ansari Sir... Ansari naam se famous hain) ke bare jante hoge maine waha se 6 months ki class kari thi fee paid kar k aur aap unse better class free me provide kra rhe ho 👍👍👍 (Shayad mai pahle ek baar padh chuka hu isliye lag rha ho). But sir mai ek baat to guarantee k sath bol skta hu aap unse jyada deeply padhate ho aur bohat se new formulas aur unke use karne ka new tarika bhi batate ho. Sir aap jo kaam kar rhe ho uske liye salute hai. Aaj bhale hi aap ki video bohat jyada na chal rhi ho but jab chalega to koi apke aas paas nhi hoga..🔥🔥🔥

[@Innozant]

Omg 😃 I am feeling Soo nice to hear that . Mujhe kaafi accha laga hai yeh sunkar ki Aapki life me Meri wajah se value add hui hai Jo ki mere liye sabse badhkar hai Maine is hi liye yeh channel bhi shuru kiya tha Mai zada kuch keh hi nahi chah raha because I am speechless aapko pata nahi chal raha hoga magar mujhe aaj tak itni khushi kisi bhi comment pe nahi hui hai at the end Mai kehna chahunga thanks Meri knowledge ko interpret karke use apne tareeke se use karne ke liye mai aapko kabhi nahi bhulunga thanks all of you for your love and support 😀🙏

[@AbhishekPandey-je5ql]

@@Innozant tum bahut achha kaam karta h maqsood bhai!!

[@vasimuddinsheikh3766]

@@AbhishekPandey-je5ql Ye maqsood bhai kon hen?

[@rashidkhan8467]

Nice sir

[@akak3585]

Thank you thank you thank you very much

[@vijaysahal4556]

nice sir aapke or mr mike ke dono ke advance excel Fun mein enjoy krta hun ^superb ^👍🏻👍🏻👍🏻👍🏻👍🏻

[@uznabee1]

Sir, I am really amazed by your teaching Excel in a so simple way that each and every thing is automatically grasped by even a lay man. Hats of you, Sir. Myself 57 yrs old but very much fond of Excel Learning for office work automation. Till now, I used to see CZcams videos and get the formulas or vba codes as per my requirement for office automation. I have also used so many times these formulas but never could understand the basic behind them. Your style/way of teaching in this video has really raised the curiosity of mine to learn more about basics not simply use cut and paste formulas. I can show you the solid effect of your teaching in this video is that I could explore to manage the conditional formatting of actual row highlighting by simply changing the initial value $A5 to $A6 for vlookup. Its all credit goes to your way of teaching Excel in so simple way. I salute to you, Sir.

[@Innozant]

Really means a lot to me sir..Happy learning.Thabks for being part of Innozant Family.

[@excellenciamadhapur9174]

Guruji, no one like you blessed me before. Thank you for your blessings. With your blessing I will definitely improve my skills in advanced excel and I will be become MIS Executive with your support. Thank you so much.

[@Innozant]

Offcourse you can...👍👍mehnat kriye ..time dijiye Kitna bhi time lag Jaye frustrate nhi hona hai..Offer letter dekhna hai mujhe Aapka MIS executive Ka ..Computer operator Ka tag Apne CV se apko hatana hai ye yaad rakhna

[@dsbohra]

X E Lent way of teaching. Well done and thanks.

[@omkarkelshikar7484]

Sir your genius 😊

[@adarshak4767]

Very nice video. Dil khush ho gaya.

[@Innozant]

Thanks dear

[@fsrajput1154]

Aapke samjhane ke tarike unique hote hain sir.

[@Innozant]

Thanks

[@sandeepaswal8944]

Sir This is fabulous. You do thing in such a creative way that makes people become to love this application.Thank you for very clearly explanations.You're savage

[@Innozant]

Thanks Sandeep for wonderful feedback from you.Aplogon ke aise valuable feedback se hi mujhe Motivation milta hai acha deliver krne ka Jo apke life me value add kare

[@hassanshahzad4964]

Your way of teaching is owseum

[@Innozant]

Thanks Hasan

[@mohdwas86]

Great video and explanation 👍

[@pramodbhavsar4488]

Very nice concept of three way lookup function with match & conditions formation thank you sir

[@Innozant]

Thanks.Pramod..there is one mistake.. Instead of A5 change it to A6 and it works perfectly fine..❤️🙏

[@itsofficialsaini]

After attempting 4times got my answer and concept of three way lookup and conditional formatting is crystal clear it's happened because of you sir 🙏 it's look like a blockbuster movies to watch again &again you are next next level teacher of excel respect from ❤️

[@Innozant]

Thanks Pawan..God bless You..Nice to see are doing. Good job

[@Demon07291]

sach he excel ka vagban ho sir ji

[@md.nur-a-asaduzzaman2578]

Wonderful... Wonderful....
so much helpful
thanks a lot sir...from Bangladesh.

[@Innozant]

Thanks dear ..God bless You..Happy learning ❤️👍

[@dipti9199]

No word how easily you have explained IndexMatch, no one can beat you sir.. Thank you for your support Every video is very helpful for us.

[@Innozant]

Thanks Dipti ,Keep Learning ❤️

[@1gopalakrishnarao]

Thanks for taking the time to share your knowledge and expertise.
We have to learn these by continuous/constant/consistent practice by looking/watching your videos. Thank you very much. Doing a great and noble job indeed. Continue your good work with ever smiling face.

[@Innozant]

Thanks Sir for such a lovely appreciation ,Must watch today @8pm -MIS INTERVIEW CRACKER new episode

[@1gopalakrishnarao]

@@Innozant Sure. Eagerly waiting for your video.

[@1gopalakrishnarao]

@@Innozant Today whether cracker new episode is there ?? I am waiting.since 8pm

[@Innozant]

Sir video is uploaded ..Kindly watch recent video Mis interview cracker #18

[@accountinghouse5633]

AWESOME SIR,THERE IS NO RESPONSE OF YOUR KNOWLEGE, LOVE YOU SIR,THANKS LOT OFF

[@Innozant]

🙏❤️ Thanks dear..Happy learning

[@binaykumarnayak9114]

So Nice Sir. Thank you. God bless you.

[@Innozant]

Thanks Binay Ji.

[@avinashghanghav2239]

Thanku soo much ..your are amazing sir

[@sumansoni3223]

Good afternoon sir, You deserve more than one like.

[@Innozant]

Thanks

[@surojdas910]

GENIOUS!!!❤❤❤

[@Innozant]

Thanks dear Suraj

[@balamira297]

Very intuitive and Excellent video sir. 😀😀

[@Innozant]

Thanks Mira..Hope you like thesw videos dear❤️❤️

[@mohammadaamirkhan7830]

Amazing Sir!
A big Thank you, Sir.

[@Innozant]

Thanks dear

[@sandipmakwana6462]

Superb.. Thank you...

[@arvindjoshi6685]

Sir, I like your teaching method.

[@PRAVEENKUMAR-cy6li]

Sir you are really great teacher for me.
Mughe jab bhi excel nai koi bhi problem aati h aapki video se bilkul clear ho jati h.
Aap ek ek baat bilakul deeply btate h.
Jo koi nhi btata h.
Very well & very nice your teaching style.
I big fan for you.
Thanks Sir. So much better

[@Innozant]

Really love you Praveen ji for such a lovely comment..Usse bhi jyada is baat ki khushi hui ki apke life me mera mehnat value add karta hai ye mere liye sabse badhke hai.
Main youtube sirf kuch tricks ya demo video banake apne video sale karne ke purpose se nahi juda hu balki koshish hai step by step complete tutorial in sequence upload karun jisse aiss student bhi jo fees afford nahi kar sakte hain wo seekh saken bht hi asani se video ke madhyam se.M trying my best ti deliver awesome content.🙏♥️🙂

[@KumarNishant181286]

Ultimate Dilip Ji, You are an Excel Wizard..

[@Innozant]

Thanks Nishant Ji

[@horrorlovestories]

Sir thank you for the most important video. I did lot of errors, I practiced again by watching video again and understood the entire concept.

[@Innozant]

Thanks ..God Bless you dear..

[@gyanapipasuasmyaham2966]

You are great sir

[@cartoonloversop6019]

सर इस विडियों के लिए मे कया कमेंट करु शब्द हि नही मिल रहे सच मे यह विडियो अद्भुत अविस्मरणीय है आपने जो मेहनत की हे वह साफ साफ दिख रही है
Fantastic 👌👌

[@Innozant]

Thanks dear.
God bless You..Happy learning dear.

[@gauravbhatia7987]

Sir yaar 🙏🙏🙏🙏🙏🙏💐💐💐💐Thnq thnq so much

[@ssrana7]

🎉 good teaching

[@nddew1493]

World के best teacher ho sir ji आप.... Excel में इतना पकड़ करोड़ों में किसी एक को ही होगा..... इतना तो जिसने excel बनाया है वो भी नहीं जानता होगा....God bless you... You are brilliant...I love you

[@Innozant]

Thanks for your valuable appreciation.. Really means a lot to me.❤️

[@PremSingh-ry7ek]

what a great way to teach

[@Innozant]

Thanks Prem ji

[@rishinbhatt82]

Sir u r ultimate great..

[@Innozant]

Thanks Rishi❤️🙏

[@tarulatabhatt4037]

Today after watching this video i came to know someone can teach like you. I am retired teacher but due to my interest I study Excel and I have never seen this type of explanation. Thankyou very much.

[@Innozant]

Really means a lot to me.Thanks for such a valuable feedback.Recommmed you to start your learning journey from Playlist-Basic Excel

[@tarulatabhatt4037]

@@Innozant I already learnt basic excel. now trying to learn advance. I watch many videos but yours is the best.

[@Innozant]

Thanks for your appreciation 🙏Happy Learning

[@Meditation5235]

Thanks a lot sir for sharing such a wonderful & informative videos. i like the way you teaching and it is very easy to understand each topic. I request to you please make a series on VBA and Power BI also. Again thanks a lot!!!

[@Innozant]

Thanks Saurabh Ji .God Bless You dear

[@itsofficialsaini]

Sir log Aapke sath hai aur woh Aapke content ko pasand kar rehe hai kyunki unhe woh chez sikhne ko milti hai Jo woh fees dekar bhi Nahi sikte hai sir aap sach mein bahut accha kar rehe hai aapni knowledge aur experience share karke 🙏 sir god bless you ❤️🙏sir

[@Innozant]

Thanks Pawan aapke itne pyar ke liye .God bless you dear

[@kinghundred]

very excellent sir

[@bhoopendraraghav9781]

Seriously I have no words, god bless u sir...

[@Innozant]

Thanks Bhoopi..One way two way aur three way teeno lookup ki practice bht achese karna hai aapko..ok.kahin bahar nhi honge interview me lookup round me.

[@bhoopendraraghav9781]

@@Innozant u are great sir...

[@mashal9211]

Sir app bahut achhi trah se teach karte ho age bhi ase hi vido bnate rahna

[@Innozant]

Thanks dear ..Sure ❤️

[@jaiyadav1256]

Oh oh superb excellent

[@Innozant]

Thanks Jai..Hope you learn from. this

[@saqibaslam2431]

Sir like your way of teaching 💯

[@Innozant]

❤️🙏

[@ashishguru9479]

sir, aapka video regular dekhta hu or aapke Jaisa easy way me koi nahi samjha sakta hai youtube par dehro video hai pr aapka content sach me lajabab hai aapki teaching style sach me lajabab hai ache guru ki talash thi jo aaj jaker pura huaa hai thori si dikat hai village me internet connection ka problem rahta hai pr aapka video sare dekhna hai aur mai aapko yakin dilata hu aapke video ke madham ye jarur kuch na kuch ban jayenge aur last yahi kahna sir aapke jaisa koi nahi hai i really like you sir.🙏🙏🙏

[@Innozant]

Thanks Ashish aapke valuable feedback ke liye ,God bless you .Life me bht aage jayenge ,mehnat Krte rehna aur frustration me aake quit mat Krna ,ache cheejon ko hone me time lgta hai

[@ashishguru9479]

​@@Innozant ✍...#Motivate करने ले लिए आपका धन्यबाद धैर्य ही सफलता की कुंजी है और समय बलवान होता है ये सत्य बस आपके मारगदर्शन की जरुरत है आपका फिर से बहुत - बहुत धन्यबाद सर और भगवान् से यही प्रार्थना करूँगा आपकी भी सारी इच्छा पूरी हो 📎❤❤❤🙏🙏🙏

[@hemantgusain1260]

Really like this concept.

[@Innozant]

Thanks Hemant.Hope you like three way lookup concept and learn applying conditional formatting too.

[@hemantgusain1260]

@@Innozant yes sir, condition formatting was great.

[@mdsani743]

Thank you sir

[@naveedmuzaffar7316]

Sir you are great excellent I really appreciated your way of teaching love you sir .this will definitely enhance your motivation UpTo peak level and you deserve for it.lastly tusi great ho.

[@Innozant]

Thanks Naveed

[@Junckook24]

Hi I always seen your useful videos and really like them and regards your efforts. Just a suggestion that for conditional formatting the best possible way to determine the formula is to use in the sheet itself and such complexed C formating it help to combined them in the sheet and easily copy paste

[@Innozant]

Thanks Naveed for your valuable appreciation, Yes Naveed You are ✅, For students for learning purpose it is a good way to apply formula on sheet the paste it into determine formula for conditional formatting

[@harivanshgautam3424]

Bohot he achhe tarike se Aapne index match 3 way lookup + conditional formatting samjhaya ek hee video me. Your every video always enhance the knowledge in excel. Very good video sir ji🙏 or apna naam bhi dekhkar achha Lagta hai. Dhanyavad Sir ji.🙏

[@Innozant]

Thanks Harivansh , Koshish yahi rehta hai ki aplogon ki concept achese samjha sakun jisse apko training alagse lene ki jrurat na ho.
Aap to dedicated student hain mere..apka naam kaise bhulenge dear.❤️😊🙏

[@harivanshgautam3424]

@@Innozantitna mehatva dene ke liye bohot bohot dhanyavad Sir ji apko 🙏🙏🙏

[@rahulram7273]

कभी कभी सिर घूम जाता है विडियो देख कर
धन्यवाद गुरु जी

[@Innozant]

Soon dear

[@mahaboobhossain5076]

Excellent video

[@Innozant]

Thanks Mahaboob.Row highlight me bus A5 ki jagah A6 le lena.ek row niche highlight ho gya tha.. example me.

[@devokedevtech2750]

Excellent sir 👌😊
Nice video

[@Innozant]

Thanks.dear❤️🙏

[@pushpisharma4432]

wow sir amazing thank you

[@Innozant]

Thanks dear

[@kashifiqbal3023]

Hi, First of all I would like to thank you to provide such a great knowledge about excel, conditional formatting is not properly working in three ways.

[@Innozant]

Kashif sahab..it's working fine dear , kindly check the video description for acknowledgement 👍❤️

[@Altaf_Alam]

Thank u so much sir for this superb video ❤️❤️❤️....plz make videos on advanced macro🤩

[@Innozant]

Thanks dear...sure

[@ashishmehrotra7308]

Good example

[@ManishVerma-gg8xl]

problem है नही है क्युकी इतने अच्छे टीचर जो हमारे साथ है और एक बात इस वीडियो को आगे की और नही बार बार पीछे स्केप करके देखा है

[@Innozant]

Thanks Manish ji❤️🙏 aapke itne valuable feedback ke liye

[@PavanKumar-cm2sz]

Wah ji wahhh
Luv u sir.....🤗

[@Innozant]

Thanks Pavan,🙏❤️ Thanks for showing your interest and choosing Innozant for Learning.Keep supporting and showing your love.

[@prochallengers8920]

Rakesh singh ji ne sahi kaha sir, aap bahut achha padhate ho.. me aapke video hamesha dekhati hu aur me meri freind ko recommend bhi karti hu , mujhe bahut kuchh naya janane ko milta hai.. me abhi Canada me hu, kai baar yeh sochati ku ki agar aap jeise log Canada me aajaye to bahot aachi life ji sakate hai.. thanks..

[@Innozant]

Thanks Shruti itne valueable aurvoyare appreciation ke liye .Mere liye sabse eham aur happiness yhi hai ki ye vidros aapke life me value add kar pa rahe hain..Aap Wahan settle ho chuke hain ya bus job ki wajahse kuch saal ke liye hain.
Koi baat nhi Ghumne hi sahi aayenge to pechaan lena aap😀mere liye yhi bht hoga..Pata chale aap pehcahane bhi nahi😀❤️🙏

[@LS8636]

Great work

[@Innozant]

Thanks Lalit Ji..Happy Learning dear

[@muhammadbilal1947]

Thank u sir ❤❤❤❤

[@Innozant]

❤️🙏thanks

[@ishutiwari5567]

i know me pehle bhi apki tareef kr chuki hu but kya kre sir rha nhi jara 😅,sir ap sach me hr topic ko itta deeply pdhate ho ki koi kuch kmi nikal hi nhi skta.apke channel ki mene in 3 4 dino me almost 200+ videos finish krdi aur hr video me kuch new seekhne ko mila.
itta deeply to koi coaching centre vale bhi nhi pdhate.shyad youtube pe esa koi channel nhi h apke alava jisne itte sare topic itte deeply cover kiye ho
bs ek hi request h sir kbhi in videos ko private mt krna.🙏
apki ye videos hum sbke ke liye bhut jyada precious h.
last me bs itna hi kehna h ki apke hard work ka fl apko ek din jror milega sir,
thank you so much🙏and,
god bless you sir😊🙏

[@Innozant]

Waah ye Aapne bolkar Dil hi Khush Kar Diya . You really made my day. 🙂arrey tension mat lo ye to bas shuruwat hai abhi bohot saari series plan Kar rakhi hai Naye Saal ke liye just wait and watch and this comment is surely the best one yet thank you for all you support 🙏
And thank again cause I am really speechless at the moment.
Omg Ishu 200+ videos in 3-4 days.. Really shows your dedication..God bless you..Bht aage jaoge life me..my best wishes always with you.👍

[@ishutiwari5567]

@@Innozant
thank you sir for your blessings. 🙏
i always wait for your videos and series😊

[@Innozant]

👍❤️Good Night..tc.

[@tarunsehgal5789]

Thanks Sir.

[@Innozant]

Thanks Tarun ji

[@atulshukal4072]

Very very good Sir

[@Innozant]

Thanks Atul Ji.. Happy Learning Sir🙏

[@krupinj.8330]

SUPERB

[@excellenciamadhapur9174]

Sir, I am very scared about excel formulas before. since 3 years from different youtube channels i am used excel formulas some how like byheart. After watching your videos explaining excel formulas with concept and examples deeply, now i am loving to understanding the formula and memorizing. =formula(what to select, next what, and(what to mention)). Really with whole hearted i love your teaching and I will not say so simple you are a teacher but I will definitely say you are my GURU.

[@Innozant]

Love you dear... Really means a lot to me..🙏❤️
Recommend you to learn step by step from basic Excel Playlist onwards then move on to Advanced Excel.
Kindly Tell me your name dear 🙂🙏

[@excellenciamadhapur9174]

@@Innozant Guruji my name is Madhusudhan(35), Working as Computer Operator I am from Hyderabad, Telangana State.

[@Innozant]

Ok dear ...Ye Aapka designation MIS Executive phir MIS Analyst ,Data Analyst sab apke naam ke aage lgega.
Mera Guru Dakshina wahi Hoga ..aap iske liye mehnat kro aur computer operator Ka tag hatake MIS executive Ka tag lagake dikhao aap❤️👍

[@kmanoj392]

Very good sir ji

[@atultiwari-ex9ow]

Dear Sir, all that you doing is very useful and innovative as you are introducing new concept for Excel users. Please don't take my comments as criticism. Actually when I watch you video, I open Excel Sheet and practice it and after running it I found some mistake so I tell you. Rest is O.K.

[@Innozant]

Not at all Atul ji...Keep learning ..👍❤️

[@Balwan_Singh]

Excellent

[@Innozant]

Thanks Balwan❤️

[@irfanhassan3074]

Thanks sir, i have one query, when i replace numerical number in place of course header the result shows #N/A and when change to text it shows accurate, so could you please guide me what will i do if have numeric number like Badge# of employee.

[@arunkumarsahu4938]

Very nice sir

[@Innozant]

Thanks Sahu ji

[@bishtlokesh1297]

Fantastic sir ji

[@Innozant]

Good Morning. Thanks ❤️ dear

[@xtreamplus9325]

very nice sir

[@Innozant]

Thanks dear

[@satishojha6240]

Hello sir Maine aapka video kabhi bhi skip kar ke nahi dekhta hu aur in future skip karunga bhi nahi kyunki mujhe poora concept sikhna hai.Thanku sir good night

[@Innozant]

Thanks Satish.❤️🙏 Happy Learning and Keep Supporting.

[@shahzadsami5613]

Amazing Information thanks Dear 1 millions honorary likes
Surprised why too less views ??

[@Innozant]

Even i don't know..😀Lagta hai viewer kp shorts video..Magic video aur tricks video hi jyada attract krta hai..
but wo main kbui shorts video na banana sirf views paane ke liye na bnaunga ..
Thanks for showing your love and trust ..God bless you.

[@rajsahu1029]

Very good

[@Innozant]

Thanks Raj

[@jayk2588]

Hi, I am a big fan of your videos. I have learned a lot from your videos atually i have learned xcel in a proper way.
I have a problen in my work, can you help me?
My problem is that, I have to find the third value based on two values, which are in a drop down means its a dynamic values, which excel shall i use? Plesae help...

[@SanjeetKumar-yx2oc]

Sir isme heading k liye agar columns merge kar rakha ho to koi fark padta hei kya conditional formating m....

[@MsExcelPakistan]

Very amazing urdu lang videos

[@Innozant]

Thanks dear❤️🙏

[@ashoksurin5860]

Sir, Dil se thank you. Ab Index aur match ek Cricket match ki trh lag rha hài, Jo mera sir dard tha.

[@Innozant]

Haha... Thanks for such a lovely comment.. Seekhiye aur aage badhiye life me

[@bickysonkar1119]

❤

[@neerajsharma-ti6kh]

Hi,
One query I have when you select Ashu Sharma the line highlight below of it instead of the selected value.i.e. Ashu Sharma for respective month

[@rahulrakshe1988]

Nice sir

[@untilanurag2178]

Hello sir , 🤩❤
Great video i often watch and take help from your valuable videos , Thanks for making such nice videos, for us it really helps us in a positive way
Just a quick question sir we often being told to create these kind of dashboards like you created here 3 way , 2 way, but sir not on the same excel sheet and definitely not on top of the data sir, please make a video where the present data is not disturbed may be some where in the corner or in the next excel sheet . please guide me😊

[@Innozant]

Sure will demonstrate in video or going to make video for the same

[@mghosh1578]

Good video

[@Innozant]

Thanks dear

[@manishkadam6724]

Hii sir. I am really astound to see such a deep knowledge I m getting from free videos . You are great and doing really good job. I m going through each and every videos day and night. . Sir I have one query about this . If we select name of a person then its course should automatically come according he is subscribed for. Can you tell me about this.

[@Innozant]

Kidnly share excel doubt and query @innozantofficial telegram id dearwill guide you

[@thirumaleshl7085]

Sir, thank you very much for your teaching
Sir, I have a dought. Why do we need to use lookup in this situation of condition formating? Instead, we can directly use the cell reference
Because lookup will also give the same result....

[@rampanja3584]

Same problem agar out put data alag workbook or months alag workbook p hoga to tab kaise kare sir..

[@abidnawaz8527]

Respected Sir.. The reference you gave for particular Row wasn't highlighted it's a different row highlighted I think you haven't selected a complete table. reply

[@RamSingh-ol5xz]

Nice 👌

[@Innozant]

Watch Full video..aur seekho saath ke saath practice..

[@RamSingh-ol5xz]

@@Innozant ok sir

[@usmantalib6127]

A. O. A
Janab , excel 2007 mai weeknum formula ka return_type 1 aur 2 hai (11, 12,13 ect) naihai tu yeh kaisay possible hai please ans. Thanks

[@vijaykumarjain3222]

Very nice sir i want to know complete. Pvoit table and i want to know how to do report connection of multiple workbooks not sheet in single pvoit table thanks again sir for your nice vedio

[@Innozant]

Thanks Jain Sahab..Pivot table videos are uploading ,you may see complete tutorial for the same soon..

[@alfabravo7415]

How to calculate two conditions in index match function (product name,pack size,and ans ...?)

[@gskiyaaden3220]

प्रणाम सर जी 🙏🙏

[@Innozant]

❤️❤️