INDEX & MATCH - One Way Lookup in Excel One Way Lookup Formula & Conditional Formatting

[@lavangjeera8147]

Bhai🙏🙏🙏🙏🙏🙏saare duniya ke excel videos ek taraf aur aapke videos ek taraf. My heartfelt salute to you.

[@Innozant]

Really means a lot to me dear

[@HarshKumar-z1f]

you are the best teacher

[@RajGopalPandit]

You are a great teacher. I learnt and practiced twice without any fault. Thanks

[@aishwaryaambasta7013]

Very useful video..it's really helps to understand one-way look-up..and questions are easy and quick to grab..

[@Innozant]

Thanks Aishwarya Happy Learning..Gn

[@vijaysahal4556]

Great sir

[@balance1772]

Bhaiya whatever I learned everything from you by watching your videos repeatedly. Now I am working in a reputed organisation. Thank you very much for practice example.

[@Innozant]

Thats grea...Have a wonderful career ahead. Never stop learning ❤️👍

[@balance1772]

@@Innozant Sure Bhaiya. Bhaiya how can I contact you? Because something I get very complicated issues in the office. That time I feel if you could be there you could have give me an idea.😃

[@Innozant]

@@balance1772 @innozantofficial telegram id

[@balance1772]

@@Innozant Thank you Bhaiya

[@sandeepaswal8944]

Sir Countless online tutorials and yours was literally the only one that made sense. Very simple way you have expressed this. you made it very simple and easy. Sir Appreciate your free help.

[@Innozant]

Thanks Sandeep for your appreciation.Yes m trying to make easy to understand videos for everyone.

[@SumitKumar-jo1fw]

Really Thanks for this video...since quite a long period of time I was looking to learn this match function...this video has solved my issues. Thanks again.

[@Innozant]

Thanks Sumit ji..Keep learning.. Keep Exploring 👍❤️

[@brijeshshah574]

Content ke sath sath aapka smile bhi bahut achcha hai Sir🙌👌🙏😊

[@blackrose6817]

Sir Apka explanation bohot accha❤❤❤

[@maddy2613]

thank you sir..your videos make excel learning very exciting.

[@umeshsharma1492]

Sir u have given thoughtful examples i have watched so many channels on these topics bt their examples are not as challenging as yours most type of which i have faced in interview you really doing a great job for the learners.

[@Innozant]

Thanks. keep learning

[@anilrajput6497]

100% samajh aa gya sir ji.. Thenkeew so much.

[@Innozant]

Thanks dear...Happy Learning

[@1gopalakrishnarao]

Interesting, Inspiring, Very Good Explanation Skills. Thank you.

[@Innozant]

Thanks Gopala Sir,Hope you are able to understand the teaching methodology and learn from there.Happy Learning Sir .tc.gn

[@naeemkhan-tm9hx]

Zabardast...MashaAllah

[@Innozant]

Thanks .. dear..Gn

[@tejpalsain1507]

Super duper formula sir jee. मजा आ गया। Thanks

[@Innozant]

Thanks Tejpal dear...

[@nishan20081]

I like the way you teach in detail

[@deepnarayandubey2383]

You are real excel guru

[@Innozant]

Thanks Deepnarayan❤️🙏

[@balakumaran75]

Nice conditional formatting trick. Thank you

[@sujoysarkar5406]

You are a very good teacher. Very useful and easy to understand.

[@Innozant]

Thanks Sujoy❤️🙏

[@hemantgusain1260]

Really helpful video for interview prospectus.

[@Innozant]

Thanks Hemant ,is topic ke 3 video aayenge abhi

[@hemantgusain1260]

@@Innozant ok sir

[@superNareshg]

Sir ur great. Thank you so much for learning. 🙏

[@Innozant]

Thanks dear

[@RakeshSingh-qo5nd]

Ur teaching style is amazing bro

[@Innozant]

Thanks Rakesh, We welcome you to experience the taste of success.🙏

[@curious1245]

Thanks for this video. Great.

[@Innozant]

Thanks Amit Happy learning

[@secretkingstatus9343]

Sir bahut hi badiya video thi maja aa gya

[@Innozant]

Thanks dear

[@shrikantbadge3978]

My favourite video. Dynamic coloring according to data.

[@Innozant]

👍❤️

[@pramodbhavsar4488]

Very useful video two way index lookup with match & conditional formatting function thank you sir

[@Innozant]

Thanks Pramod ji.Good Night🙏❤️

[@nadeemahmed8762]

Sir. Bhot aage jaenga aap KZbin pa.🔥♥️.aisa hi video banate rhe🔥

[@Innozant]

Thanks Nadeem...Pivot Table Show value as full pack video uploaded..Must watch

[@saiyadazazali3243]

superb all excel video

[@kanchanyadav1240]

Thank you for updating my knowledge

[@Innozant]

Thanks Kanchan ji

[@ArmanKhan-iq3ji]

Thank u so much sir, I forget index and match function but today I have learn more 😊.

[@Innozant]

ohh..Thanks Arman Khan sahab..Keep.learning..keep sharing

[@surajrajput2752]

Congrats sir g add mil gya aapko👍

[@Innozant]

❤️😂

[@bishtlokesh1297]

Awesome topic useful topic for excel users

[@Innozant]

Thanks Lokesh..hv a nice day

[@Jitenderkumar-yp1rn]

V.good example sir jii...🔥🔥😍

[@Innozant]

😊👍

[@ROHITKUMAR-te9pk]

Very good logic

[@vijaysahal4556]

Hii sir mere wow amazing nd loving teaching way of unique blog class me whole world mein sirf 3 name hai izzozant nd ,excel fun mike girvin nd Leila Gharani's KZbin channel thanku very mch aap tino ko

[@Innozant]

Thanks Vijay ji for sucha a lovely appreciation.Really means a lot to me dear

[@ranvirvashisht1415]

Ggg

[@bhoodevbasicinformation]

very good Great Video

[@asimali5820]

Wonderful!

[@shahzadsiddiqui5117]

very very very good..!

[@md.taifuranam7904]

Excellent Brother, Your teaching method is very easier to understand. I have started to learn excel from your channel. Now I am in the intermediate stage in excel, and want to move to advanced. Pls, advise me how it is possible.

[@Innozant]

Great ..kindly watch MIS LEARNING PROCESS video from our career guide playlist or find out videos in sequence playlist in video description

[@satishmestry5687]

Very nice sir. informative video.

[@Innozant]

Thanks dear🙏❤️

[@user-ej9pz5zd5i]

Outstanding...

[@RohitKumar-cc7zi]

Very good way to teach, awesome

[@Innozant]

Thanks Rohit Ji🙏❤️gn

[@akak3585]

Thank you sirG

[@DineshSingh-lc5gk]

Gr8 Sir❤

[@DineshSingh-lc5gk]

Sir, Finally Maine horizontal sum ko solve kar liya index match se. Thanks to you. But sir jab main index match wale file ko close karta hu to link file se value gayab ho jati hai. Kyo?

[@ajinkyashinde1778]

Excellent 👍👌👌

[@Innozant]

Thanka Ajjnkya Ji.,🙂

[@karankapoor200]

very important video 👌🏻

[@Innozant]

👍❤️😊

[@karankapoor200]

@@Innozant you are best teacher sir apa asahi pada ta rahiya sir ma to bhagwan say ya hi pry karuga ki apa kafi tarki kara life apki sari icha puri ho jay OK by sir milta h kanbhi sir kabhi Agra ajaya 👌🏻🎂🎂

[@Innozant]

Sure aayenge to milenge dEar

[@kinghundred]

very excellent sir

[@VikramKumar-du2mw]

Mast Sir 👌👌👌👌

[@mrsswetakumari8089]

excellent sir 👌👍

[@Innozant]

Thanks Sweta🙏♥️🙂We welcome you to experience the taste of success with Innozant- Seed of Success

[@msexcelgooglesheet374]

I love the conditional formating .............

[@Innozant]

Thanks 😊🙏

[@shaileshkumar-qf6bd]

Than you so much sir

[@gauravbhatia7987]

Thnq sir bohat bohat thnq

[@Kingx7565]

Love from Pakistan Sir

[@Innozant]

Thanks Hasnain sahab..Happy learning dear..we welcome you to experience the taste of success with innozant .Recommend you to start you learning journey from basic excel onwards.(videos in sequence playlist link given in video descripntion)

[@bishtlokesh1297]

It's so good ❤️

[@Innozant]

Thanks

[@manishkumarpingolia393]

Very nice 👍

[@Innozant]

Thanks Manish Ji👍❤️

[@saahilsaahil5912]

Amazingggggggggggg👌👌

[@Innozant]

Thanks

[@kirtisharma2373]

😊Great....

[@Innozant]

Thanks Kirti

[@jaspalrana9541]

Amazing 👌

[@Innozant]

Thanks Jaspal Ji.

[@Demon07291]

maja ata h shikne me , or kya chahiya sir ji, thanks for your hardwork,

[@Innozant]

Thanks Shubha

[@bhoopendraraghav9781]

Wow very nice.

[@Innozant]

Thanks Bhoopendra..Gn

[@bhoopendraraghav9781]

@@Innozant gn sir g

[@jamalibrahim3229]

amazing!

[@Innozant]

Thanks

[@SouravKumarRoy651]

Sir, I have one question ⁉️ In conditional formatting, while writing the formula, why we have written

[@prochallengers8920]

thank you sir...

[@Innozant]

Thanks Shruti, Happy Learning dear.God bless you🙏🙏❤️❤️

[@sachinkamble1926]

Sir your traning is nice

[@Innozant]

Thanks Kamble ji.happy learning

[@sachinkamble1926]

Muze ek query hai

[@sachinkamble1926]

jab ek sheet se dusare sheet me vlookup+match function lagate hi to 1st wali lookup value ko freedge karte to peefect answer ata hai but vahi same agar ek work book se dusare workbook me lagate hai 1st wali lookup value ko freedge karte hai to formula pure table ko apply nahi hota hai aisa q?

[@saudagarawais599]

sir i request you please make a series of VBA and macros

[@Innozant]

After Excel.videos..Will plan to start a new series on Other tool.

[@devokedevtech2750]

Super sir

[@Innozant]

Thanks Dheeraj ji

[@RamSingh-ol5xz]

Nice 👌

[@Innozant]

Thanks Ram

[@sachinrv1]

Offset also works fine. The only thing is it is complex.

[@sumitrawat-x4k]

sir please can you taught how we use vlookup with sum in first exp

[@ishutiwari5567]

8:28 sir mene ye formula use kiya sum krne ke liye =SUM(OFFSET(B1,1,0,MATCH(D2,A2:A13,0),1))

[@Innozant]

Biklul Sahi Kiya hai Ishu..👍👍❤️❤️

[@ishutiwari5567]

@@Innozant thank you sir🙏😊

[@AmitKumar-xi3oe]

Plz you can help me find last billing date in sales data in party wise

[@umeshgajjar1908]

What is the function to be used for dynamic condition for conditional formatting on above scenario i.e Apr to Jun not from Jan

[@HabibUllah-cw7do]

Same question from me also

[@asifkhurshid9208]

Great and excellent, Sir how can we Join you., kindly reply.

[@Innozant]

Thanks Asif,You may contact us via call/whatsapp for more information on Live classes

[@m.rshagorahmed716]

Very Nice Video Sir 1 request Plz Uplode (Ofset )funtion Video

[@Innozant]

Thanks..Dear..Lookup series Basic to Adv. Uploaded in Sequence.After Index Match,Choose.then indirect after that offset videos uploaded.Havr patience 😊🙏

[@saideewani2319]

sir ye jo apne sum kia h sales ka usme index match ki jgh vlookup lga skte h?

[@Innozant]

Offcourse Neha jo kaam index se hoga wo vlookup se bhi kr skte hain...aap lagao aur mujhe btao ydi koi issue aata hao to...❤️🙏formula show krna ki aapne kya kiya

[@Harish.Prasad.Semwal]

1:26 2:48 6:07 8:23 (IMP 1) 11:12 (IMP 2)

[@rajeevdubey2668]

Sir I want know how to make unique value with vlookup in two sheets

[@umeshgajjar1908]

Nice

[@Innozant]

Thanks Umesh..❤️

[@bikashkumarparida7595]

sir how to use vlook up instead off index match in this problems

[@shadab917]

Sir When I am passing zero for row number it is giving me Spill error...

[@aqeelahmadengr3]

Liked

[@Innozant]

Thanks

[@AbhishekKumar-nb4et]

Sir isme confidential f. Me

[@vikkynarepagul256]

Can't apply rows in conditional formatting

[@sanjaypandharpure6248]

Sir, I have tried Index Match Sum yr, same example Sum Jan, Up to Intended Month, on different work sheet with indirect but not executing formula, can you help me. How can i send that file to you

[@sunnykhowal3311]

Sir exel b dedo practice k liye

[@Innozant]

Wo to download kr lijiye..

[@pawanjounkani]

I love your videos as they clear the concepts but my confusion is that in this video you asked to solve the method by vlookup also but according to the concept, vloopkup uses columns only and not the rows. I think hlookup will be used in this case. Correct me if I am wrong. Waiting for reply.

[@Innozant]

Thanks..Dear Pawan kindly again listen what I said..🙂We will use hlookup when our lookup value is available in 1st row.

[@johnchristopher2403]

Sir, can I do H-Lookup across 2 worksheets of the same workbook in googlesheets?

[@Innozant]

How the data format is?yes we can

[@johnchristopher2403]

@@Innozant Sir, can you help me? Is there a video or can I email you?

[@dhakafady774]

sir i tried to do this with vlookup , result isn't showing sir i wrote furmula SUM(B2:VLOOKUP($D$2,$A$2:$B$13,2,0)) sir with i made mistake , sir would you mind to fix this problem ?

[@jaynandangiri4401]

But ye Sumifs bhi to kar skte hai

[@Innozant]

Yes . Kyu nahi

[@pawanwakale8801]

Sir apne luch examples liye jisme me digit ke pahle $ sign hai , uska jab sum kiya toh 0 ata hai aur jab $ sign hataya to answer dhila hai , with $ sign answer kaise ayenga isme thoda help chahiye

[@yogeshkumar-hs6ih]

Sir ye vlookup+Match se kaise kiya ja sakta hai please explain

[@Innozant]

Vlookup se bhi ho jayega..try Kiya aapne

[@yogeshkumar-hs6ih]

Ji but mujhe range ko dynamic rakhkar iska solution nahi mil raha hai {2,3,4} ki jagha par kya lagya jaye jisse formula dynamic ho jaye

[@NeerajKumar-hd1km]

Sir, can we sum from May to Aug month

[@Innozant]

Yes we can..need to make both range dynamic

[@foroutarpitsingh8126]

vlookup se kaise krege...plz tell

[@nitrogaming3188]

13:46 sir ye sum krne ka tarika vlookup se nhi ho raha please help

[@Innozant]

Kya issue aa raha hai dear ?

[@faahimrafi8720]

I didn't get the point. Isn't INDEX MATCH supposed to pick the value of the cell? How did it pick up the cell address?

[@vready4all]

Sir, I got exact result by applying Vlookup with {} (curly braces) is it right approach Sir? or is there any method? I request you to kindly reply me sir.

[@Innozant]

Ok .under curly braces how you you pass your argument..kindly show me your formula. Really nice to see you are trying to apply different method..M happy for you dear.

[@vready4all]

@@Innozant Sir Thank you very much for your reply. My formula are as under - For Table 1 {=SUMPRODUCT(HLOOKUP(A4,$A$5:$D$8,{2,3,4},0))} For Table 2 {=SUM(VLOOKUP(A13,$A$14:$D$17,{2,3,4},0))} Sir, is there any other formulas, if yes, kindly share the same please.

[@Maayu_Vijay]

@@vready4all thanks

[@vready4all]

@@Maayu_Vijay Thank you

[@amitpyasi2819]

Please sir uploaded video office 365

[@Innozant]

Soon we will start office 365 series

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

[@shwetkumar1719]

vlookup se kaise krege sir?

[@premchandraroy7174]

Sir index jab ek hi raw aur colum ke ek hi cell se data uthata hai to ye sum Kaise karta h main samajh nahi paya sir pls explain.