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

[@akak3585]

Thank you thank you thank you very much

[@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

[@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 KZbin 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.

[@dsbohra]

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

[@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

[@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

[@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

[@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 ❤️

[@fsrajput1154]

Aapke samjhane ke tarike unique hote hain sir.

[@Innozant]

Thanks

[@hassanshahzad4964]

Your way of teaching is owseum

[@Innozant]

Thanks Hasan

[@accountinghouse5633]

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

[@Innozant]

🙏❤️ Thanks dear..Happy 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

[@sumansoni3223]

Good afternoon sir, You deserve more than one like.

[@Innozant]

Thanks

[@vijaysahal4556]

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

[@omkarkelshikar7484]

Sir your genius 😊

[@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 ❤️👍

[@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..❤️🙏

[@mohdwas86]

Great video and explanation 👍

[@arvindjoshi6685]

Sir, I like your teaching method.

[@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

[@binaykumarnayak9114]

So Nice Sir. Thank you. God bless you.

[@Innozant]

Thanks Binay Ji.

[@adarshak4767]

Very nice video. Dil khush ho gaya.

[@Innozant]

Thanks dear

[@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.🙏♥️🙂

[@avinashghanghav2239]

Thanku soo much ..your are amazing sir

[@sandipmakwana6462]

Superb.. Thank you...

[@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..

[@KumarNishant181286]

Ultimate Dilip Ji, You are an Excel Wizard..

[@Innozant]

Thanks Nishant Ji

[@mohammadaamirkhan7830]

Amazing Sir! A big Thank you, Sir.

[@Innozant]

Thanks dear

[@balamira297]

Very intuitive and Excellent video sir. 😀😀

[@Innozant]

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

[@cartoonloversop6019]

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

[@Innozant]

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

[@surojdas910]

GENIOUS!!!❤❤❤

[@Innozant]

Thanks dear Suraj

[@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.❤️

[@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...

[@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 👍❤️

[@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

[@saqibaslam2431]

Sir like your way of teaching 💯

[@Innozant]

❤️🙏

[@rishinbhatt82]

Sir u r ultimate great..

[@Innozant]

Thanks Rishi❤️🙏

[@ssrana7]

🎉 good teaching

[@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

[@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

[@gyanapipasuasmyaham2966]

You are great sir

[@gauravbhatia7987]

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

[@PremSingh-ry7ek]

what a great way to teach

[@Innozant]

Thanks Prem ji

[@mashal9211]

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

[@Innozant]

Thanks dear ..Sure ❤️

[@kinghundred]

very excellent sir

[@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 🙏🙏🙏

[@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.

[@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 करने ले लिए आपका धन्यबाद धैर्य ही सफलता की कुंजी है और समय बलवान होता है ये सत्य बस आपके मारगदर्शन की जरुरत है आपका फिर से बहुत - बहुत धन्यबाद सर और भगवान् से यही प्रार्थना करूँगा आपकी भी सारी इच्छा पूरी हो 📎❤❤❤🙏🙏🙏

[@Altaf_Alam]

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

[@Innozant]

Thanks dear...sure

[@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

[@ManishVerma-gg8xl]

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

[@Innozant]

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

[@jaiyadav1256]

Oh oh superb excellent

[@Innozant]

Thanks Jai..Hope you learn from. this

[@mdsani743]

Thank you sir

[@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😀❤️🙏

[@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

[@rahulram7273]

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

[@Innozant]

Soon dear

[@pushpisharma4432]

wow sir amazing thank you

[@Innozant]

Thanks 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❤️🙏

[@ashishmehrotra7308]

Good example

[@muhammadbilal1947]

Thank u sir ❤❤❤❤

[@Innozant]

❤️🙏thanks

[@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❤️👍

[@LS8636]

Great work

[@Innozant]

Thanks Lalit Ji..Happy Learning dear

[@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.

[@tarunsehgal5789]

Thanks Sir.

[@Innozant]

Thanks Tarun 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 ..👍❤️

[@bishtlokesh1297]

Fantastic sir ji

[@Innozant]

Good Morning. Thanks ❤️ dear

[@atulshukal4072]

Very very good Sir

[@Innozant]

Thanks Atul Ji.. Happy Learning Sir🙏

[@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.

[@kmanoj392]

Very good sir ji

[@krupinj.8330]

SUPERB

[@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.

[@Balwan_Singh]

Excellent

[@Innozant]

Thanks Balwan❤️

[@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

[@arunkumarsahu4938]

Very nice sir

[@Innozant]

Thanks Sahu ji

[@MsExcelPakistan]

Very amazing urdu lang videos

[@Innozant]

Thanks dear❤️🙏

[@xtreamplus9325]

very nice sir

[@Innozant]

Thanks dear

[@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...

[@Harish.Prasad.Semwal]

4:29 6:33 7:48 (Conditional Formating 1) 9:59 (Consditonal Formating 2) 12:37 (Intersection Conditional Formating)

[@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.

[@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

[@rajsahu1029]

Very good

[@Innozant]

Thanks Raj

[@rahulrakshe1988]

Nice sir

[@bickysonkar1119]

❤

[@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....

[@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

[@RamSingh-ol5xz]

Nice 👌

[@Innozant]

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

[@RamSingh-ol5xz]

@@Innozant ok sir

[@gskiyaaden3220]

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

[@Innozant]

❤️❤️

[@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..

[@sachinrv1]

EVEN SUMPRODUCT CAN WORK WELL HERE, PROVIDED EACH AND EVERY RECORD IS UNIQUE. COMBO OF XLOOKUP AND FILTER WILL ALSO DO THE TRICK.

[@udaymal8017]

wow

[@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.

[@shivammishra-bf6vp]

Awsm sir mtlb kya he bolu, 🙏🏻🙏🏻🙏🏻

[@Innozant]

Thanks Shivam

[@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

[@kanchanyadav1240]

NICE VEIDIO

[@Innozant]

Thanks Kanchan ji❤️❤️