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

[@RockOn350]

Awesome Conditional Formatting Sirji...😍

[@pravinkumbhare1750]

Bahot hi badhiya example hai aur aapne bahut hi achha samjhaya hai Sir .. Thank You...

[@Innozant]

Thanks Pravin Ji

[@arshadkhan2125]

Great sir from Pakistan making such great videos.🌹🌹🌹🌹

[@Innozant]

Thanks Arshad khana sahab..hope you are fine and doing well ik your life..happy learning 🙏🙏❤️❤️

[@sandeepaswal8944]

Wow!Sir You are super concise and articulate! It's very impressive how smooth your overall oral presentation was on Excell. You have a great voice too! You could totally do voice overs and do very well in my opinion. Thanks so much for sharing this video with us. 😊

[@Innozant]

❤️😊😊🙏🙏No words Sandeep.. Your skills really improve a lot.

[@satishmestry5687]

Zabaradast Sir. Your teaching method is unique.

[@Innozant]

Thanks Satish Ji🙏❤️

[@srikanthpillamari6598]

bohot bohot shukriya bhai.....

[@bhoopendraraghav9781]

Never seen such an example before thanks sir...

[@jaisan5582]

YOU GREAT MASTER JI. PRANAAM.

[@Innozant]

Thanks Jai

[@akak3585]

Great sirG

[@gauravbhatia7987]

Je mera apne concept clear kardiya apne sir thnq index match formulas ka sir thnq

[@shrikantbadge3978]

Good to be back on Dipak Sirs channel. Lost the touch on videos due to heaps of work. Lot of videos are uploaded now. Lot to learn. Lot to revise. Thanks Sirji.

[@Innozant]

Oh .No issue Shrikant Ji, Happy Learning..Keep watching ,Learn and share.

[@dheerajvaid8731]

Through your videos , I have gain good knowledge and really impressed my boss too..thank you sir

[@Innozant]

Thanks Dheeraj ❤️

[@bhuwanchandrapathak4617]

excellent method for teaching

[@shrikantbadge3978]

Probably my third comment now. It's always good to see you Dear Dilip sir. Pranam.

[@Innozant]

Thanks Shrikant Ji

[@brijnarayan1234]

kya samjhaya hai sir, jabardust....

[@Innozant]

Thanks Brij Narayan.. Innozant Family se Judne ke liye Sukriya .Yadi aap Biklul 0 se learning start Karna chahte Hain to playlist Basic Excel Se start kijiye .❤️🙏

[@bhushankurambhatti1427]

Excellent sir really helpful

[@pandharinathjoshi6565]

Great sir...super👍👌

[@Innozant]

Thanks Joshi ji

[@naeemkhan-tm9hx]

Excellent and unique

[@Innozant]

🙏😊❤️

[@pramodkumar-ke8gd]

Great Sir, I am very thankful to you

[@Innozant]

Thanks Pramod Ji❤🙏

[@ShivKumar-qz8ct]

I was already waiting this concepts. Thanks Sir !!

[@Innozant]

😊🙏

[@tt_badmash_9560]

Excellent sir

[@Soft-tips-tricks]

Most useful concept

[@Innozant]

🙏❤️😊

[@ssaap1212121121]

Sir i want to sum of deeksha for feb month. what should be formula for this condition....

[@kinghundred]

very excellent sir

[@devokedevtech2750]

Nice video 👍

[@mdsani743]

Thank you sir

[@RahulChauhan-ll9pu]

Superb sir.

[@Innozant]

Thanks Rahul Ji👍❤️🙏

[@RamSingh-ol5xz]

BHUT bhut Acha hai lagaa

[@Innozant]

❤️😊

[@sumitjaiswal4391]

Great Vedio sir

[@Innozant]

Thanks

[@nirala5]

Sir very nice example

[@Innozant]

Thanks Kunal, Welcome you to experience the taste of success.Enhance your skills.Have a blooming career ahead.😊❤️🙏

[@vikkynarepagul256]

Sir kindly guide us on conditional formatting Not able to do as u done in the video

[@RahulKumar-ly6ly]

Thanks a lot sir ji

[@Innozant]

Thanks Rahul Ji❤️

[@Bongviewfinder]

Sir If we need to sum of feb to march for Ram Sing what we will do sir

[@rhashmi1]

Amazing

[@Rejuanhaque]

Superb

[@Innozant]

Thanks dear🙏❤️👍

[@satishojha6240]

Thanks sir very nice this is really helpful to interview purpose have a sweet dream sir.

[@Innozant]

🙏❤️😊

[@Harish.Prasad.Semwal]

2:04 : 5:50 10:09 (Conditional Formating)

[@chandrakanthlaxman2917]

Sir, at the beginning, you have shown that , whenever we change candidate name or month name accordingly values changing, but it should not happen.

[@brittokhan5278]

Sir, what is scratch you have mentioned several times?

[@naseemakbar6962]

Sir ye to uper uper nikal gaya 😃😃😃

[@Innozant]

Why dear

[@arban451]

Thank you so much sir

[@Innozant]

👍❤️😊

[@rashidkhan8467]

Nice sir

[@bazzelrahman5879]

Sir iss video me apne jo dataset use Kiya hai, uska link share kar sakte hai kya practice ke liye?!

[@fsgaming6850]

Sir ! How we solve this with vlookup method..

[@tejpalsain1507]

Helpful .

[@muhammadbilal1947]

❤❤❤❤

[@Innozant]

❤️🙏

[@akingsofficialanishregmi3439]

Dear Sir, In the same function, how to sum only the value of Jan, Mar & April and so on... plz reply i need this...pls mail me the solution at soon

[@devendergusain8974]

sir ye two way or more than one way vlookup se ho skta hai kya ? nestedvlookup lgana pdga?

[@Innozant]

Haan iferro ke saath paas kar lijiye nested vlookup

[@neerajtomar9018]

Sir aap jis tarha se mis sikha rahe ho wo apne aap main bahut aacha hai main aap ki sari video dekhta hu bs sir jis tarha se mis ki video banate ho vba ki bhi video banao sir main vba ki video ka intjar kar raha hu plz sir vba par bhi video banao sir

[@Innozant]

Haan dear banahenge ..pehle Excel ..power series ke bht video aane hain abhi..ek saath bht saare olaylist manage nhu kiya ja sakta h thats why

[@vikkynarepagul256]

"Kaha se" in that what key u are pressing pls let us know

[@Innozant]

Using F9

[@excel_point]

Sir vba macros ka class late hai Kya jaise excel ka lete hai kya

[@Innozant]

Yes dear..iska bhi series kuch time baad krenge start

[@excel_point]

@@Innozant thank you so much sir jaldi start kijiyega i am waiting for your vba macros series plz sir

[@excel_point]

sir mai MIS ka preparing krta hoo 2 month se plz sir mera guidance kijiye sir mujhe aapka vidio hi achha lagta hai sir plz apna whatssap no. dijiye jisse hmko kuchh suggestion lena ho ya question to mai aapse sidha cotect ker skoo plz sir

[@tejpalsain1507]

Nice

[@Innozant]

😊🙏

[@virendersroha1754]

Sir exl me fount increase short cut key kya h

[@Innozant]

Ctrl+shift+p

[@virendersroha1754]

@@Innozant sr isse to format cells open ho rha h Alt HFS arrow up and down se ho rha h

[@ingeniousbposervices2876]

sr excel me fount increase short cut key kya h

[@Innozant]

Ctrl+shift+p

[@untilanurag2178]

Great video sir really i always watch ur videos and learn new things just a quick question. In the sum index function I am not able to understand we are doing sum from where to where coz the value we are getting is different from the table in the output is it because of the rand between function you have used.

[@amazingindiabyshiva8357]

Jabardast

[@someonefrom2002]

Sir last question ko agar vlookup se try karte hai toh vo hota hi nhi hai but index se ho jata hai aisa q, jbki f9 karne per same value hi dono return karke sum ko de rhe hai

[@PARVEENKUMAR-db5be]

Sir, Aapka excel full course ka video hai kya?

[@Innozant]

Yes Video course of Mastering Excel is available,You may contact Team Innozant and buy your course

[@vishalshelar697]

Wow sir🙏, is it possible create graph as per the name and till month..

[@Innozant]

Yes..kyu nhi

[@vishalshelar697]

Thanks for your reply.. could you please teach us to make such kind of chart graph 🙏

[@bishtlokesh1297]

😊😊😊😊

[@BalvirSingh-qs9kz]

Sir, bada deta hai & last deta ko high light hokar on dikaye ????

[@Innozant]

Phirse explain kijiye query ek baar nhinhua mujhe clear aa kya karna chahte hain

[@sudhakarverma4705]

Kya baat h sir

[@Innozant]

Thanks Sudhakar ji

[@aqeelahmadengr3]

Liked

[@Innozant]

Thanks

[@hemantgusain1260]

Thanks you sir but I need to understand it deeply. I am able to understand index with match and match.

[@Innozant]

Soon more videos uploaded..dear

[@hemantgusain1260]

@@Innozantsir jo aap first index laga rahe ho woh samaj nahi aaya. index with double match samaj aata hai. Usko samajhne ke liye kya karna chahiye.

[@Innozant]

Aap video Dhyan se dekhiye.pehla index means from where we want to add : dusra index to simple hai wo humlog use karte hi hain always.

[@hemantgusain1260]

@@Innozant ok I will watch again this video.

[@devendergusain8974]

best

[@Innozant]

Thanks Gusain sahab

[@GudduSharma-jd4ig]

Hello sir..apki video se me bahut kuch sikh payi hun all thanks to you...but ye video me jo apne second condition lagayi hai for conditional formatting ke liye vo samajh hi nahi aaya uper se chala gaya sab....Pls bataye kese samjhu ise?

[@Innozant]

conditional formatting to aasana hai iska ydi rows less than equal to match tak hai to color krna hai.ek baar js video kp dhyan se phir dekhiye aayega samajh

[@awanishanurag1763]

Conditional Formatting isme samajh nahi aaya banki sab samajh aa gaya!

[@kishorpanara4191]

Sir aap data me $ ki jaga pe ₹ rakha karo ye ek suggestion hai

[@Innozant]

Ok..Kishore.. Currency change kr denge aage se..waise aksar rupees hi rehta hai but format sheet me change ho Jane ki wajahse dollar .🙏

[@umeshgajjar1908]

Sir, I am having data on following patern Year/Month Jan Feb Mar 2019 100 200 60 2020. 50 60 80 2021. 20 50 300 Now I want year and month of Max value (i.e Mar 2022) Which formula to be used

[@ROHITKUMAR-te9pk]

One way lookup to samajh me aagya but ye samajhne me thora problem horaha hai koye Or condition lagye ne

[@mohd.sameer3191]

Sir please see this formula, this formula is getting error =AND($B134=$B$131),COLUMNS($C134:C134)

[@abdulsalam935]

Remove bracket ) after $B$131

[@nishachauhan5636]

When we type formula than it hide the background data which wil select Than how can we get this 3:34

[@jhansihits249]

Sir online class ho sakti h

[@Innozant]

Haan online/offline dono batches chalte hain,For more information kindly connect with Team Innozant or visit Innozant website

[@sumitjaiswal4391]

But How to build logic..

[@Innozant]

Time ke saath aane lagega dear logic build karna

[@devokedevtech2750]

Sir agar min value with index match se nikalna ho or dono lookup value column me ho to kese krenge mene krke dekha output nhi aa rha h sir koe salution ho to please share formula

[@Innozant]

Mx min with index match video bhi isi series me aayega ya upcoming playlist me

[@zakariamahmudiqbal8007]

It does not work in online excel. Whatever, Thank you. SIR 🌍

[@sudhakarverma4705]

Aap to great mis h 1 se 1.5 lack tak mis kar sakte h

[@tarjitmalka3978]

⭐⭐⭐⭐⭐

[@Innozant]

🙏

[@RakeshSingh-qo5nd]

Apki video bilkul waisi hai jaisa maine last video pe comment kiya tha "amazing"..... And apne excel sheet pe mera name bhi likha hai kya mere comment ki wajah se apke mind ko trigger kiya tha????

[@Innozant]

Yes Rakesh ,You are Right😊❤️👍 Happy Learning dear..Aaj ke Video aur bhi Amazing... Uploading soon

[@balamira297]

the conditional formatting thoda confusing hai sir!

[@Innozant]

Kyu Mira kya samjh nhi aa Raha hai aapko..ydi doubt clear na ho to aap live connect kar Lena mujhe via zoom.Ok..yaad nhi karna hai smjh ke Karna hai..ok

[@balamira297]

@@Innozant I'll try to understand once again sir..if not connect karoongi aap ke saath.

[@Innozant]

Thats very Good..Try to understand how I did step by step and let me know .👍

[@RamSingh-ol5xz]

Nice sir Mera BHI name ram Singh

[@Innozant]

Wo aapka hi name hai dear....

[@RamSingh-ol5xz]

Sir

[@umehabiba5041]

hello sir, i need your help to solve my problem actually in my first column i have 350 companies in next column i have years 2005-2018 for each company.....and in third column i have each company directors for each year..if 1 company has 14 or 15 directors, than other company has 6,this information is also vertical....i want to transform directors column from vertical to horizonatal for each company and for each year like abc company, year 2009, director aslam,qaynat,huma, adnan etc....please help me to solve this problem...thank you

[@Innozant]

Dear it's better you may send your Excel sheet with query explanation @innozantoficial telegram id

[@msexcelgooglesheet374]

Sir ji , everything is going perfect until I reached "CONDITIONAL FORMATTING"...........🤣(sir aapto smjh dete ho agar thoda sa bhi change hota hai to nhi banta)

[@Innozant]

Hahaa...Innocent and true reply..Video Dhyan se dekha aur smjha😀 kijiye,main bht detail m smjhane ki koshish krta hu..phir apply kijiye.. 😊❤️🙏

[@manishgupta-ee3nb]

Amazing

[@meriawaazhindi5217]

❤️❤️❤️❤️❤️