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

INDEX & MATCH - One Way Lookup in Excel One Way Lookup Formula & Conditional Formatting
1. One way lookup using Index & Match in Excel
2. Sum range of data using Index Match Function
3. Conditional Formatting & Match Function in Excel
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
(Playlist Folder-Excel Lookup Functions-OneWayLookup.xlsx)
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#onewaylookupinexcel #onewaylookup#Innozant #exceltuorial #indexmatch #misinterviewquestions

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

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

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

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

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

[@maddy2613]

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

[@brijeshshah574]

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

[@blackrose6817]

Sir Apka explanation bohot accha❤❤❤

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

[@nishan20081]

I like the way you teach in detail

[@balakumaran75]

Nice conditional formatting trick. Thank you

[@superNareshg]

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

[@Innozant]

Thanks dear

[@anilrajput6497]

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

[@Innozant]

Thanks dear...Happy Learning

[@sujoysarkar5406]

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

[@Innozant]

Thanks Sujoy❤️🙏

[@tejpalsain1507]

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

[@Innozant]

Thanks Tejpal dear...

[@deepnarayandubey2383]

You are real excel guru

[@Innozant]

Thanks Deepnarayan❤️🙏

[@hemantgusain1260]

Really helpful video for interview prospectus.

[@Innozant]

Thanks Hemant ,is topic ke 3 video aayenge abhi

[@hemantgusain1260]

@@Innozant ok sir

[@curious1245]

Thanks for this video. Great.

[@Innozant]

Thanks Amit Happy learning

[@RakeshSingh-qo5nd]

Ur teaching style is amazing bro

[@Innozant]

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

[@naeemkhan-tm9hx]

Zabardast...MashaAllah

[@Innozant]

Thanks .. dear..Gn

[@pramodbhavsar4488]

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

[@Innozant]

Thanks Pramod ji.Good Night🙏❤️

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

[@secretkingstatus9343]

Sir bahut hi badiya video thi maja aa gya

[@Innozant]

Thanks dear

[@shrikantbadge3978]

My favourite video. Dynamic coloring according to data.

[@Innozant]

👍❤️

[@Harish.Prasad.Semwal]

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

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

[@kanchanyadav1240]

Thank you for updating my knowledge

[@Innozant]

Thanks Kanchan ji

[@saiyadazazali3243]

superb all excel video

[@bhoodevbasicinformation]

very good Great Video

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

[@satishmestry5687]

Very nice sir. informative video.

[@Innozant]

Thanks dear🙏❤️

[@bishtlokesh1297]

Awesome topic useful topic for excel users

[@Innozant]

Thanks Lokesh..hv a nice day

[@ROHITKUMAR-te9pk]

Very good logic

[@shahzadsiddiqui5117]

very very very good..!

[@RohitKumar-cc7zi]

Very good way to teach, awesome

[@Innozant]

Thanks Rohit Ji🙏❤️gn

[@asimali5820]

Wonderful!

[@Jitenderkumar-yp1rn]

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

[@Innozant]

😊👍

[@surajrajput2752]

Congrats sir g add mil gya aapko👍

[@Innozant]

❤️😂

[@user-ej9pz5zd5i]

Outstanding...

[@ajinkyashinde1778]

Excellent 👍👌👌

[@Innozant]

Thanka Ajjnkya Ji.,🙂

[@akak3585]

Thank you sirG

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

[@SouravKumarRoy651]

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

[@Demon07291]

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

[@Innozant]

Thanks Shubha

[@sachinrv1]

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

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

[@shaileshkumar-qf6bd]

Than you so much sir

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

[@manishkumarpingolia393]

Very nice 👍

[@Innozant]

Thanks Manish Ji👍❤️

[@msexcelgooglesheet374]

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

[@Innozant]

Thanks 😊🙏

[@kirtisharma2373]

😊Great....

[@Innozant]

Thanks Kirti

[@gauravbhatia7987]

Thnq sir bohat bohat thnq

[@bishtlokesh1297]

It's so good ❤️

[@Innozant]

Thanks

[@saahilsaahil5912]

Amazingggggggggggg👌👌

[@Innozant]

Thanks

[@jaspalrana9541]

Amazing 👌

[@Innozant]

Thanks Jaspal Ji.

[@bhoopendraraghav9781]

Wow very nice.

[@Innozant]

Thanks Bhoopendra..Gn

[@bhoopendraraghav9781]

@@Innozant gn sir g

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

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

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

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

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

[@jamalibrahim3229]

amazing!

[@Innozant]

Thanks

[@sumitrawat-x4k]

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

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

[@prochallengers8920]

thank you sir...

[@Innozant]

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

[@RamSingh-ol5xz]

Nice 👌

[@Innozant]

Thanks Ram

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

[@devokedevtech2750]

Super sir

[@Innozant]

Thanks Dheeraj ji

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

[@nitrogaming3188]

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

[@Innozant]

Kya issue aa raha hai dear ?

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

[@shadab917]

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

[@vikkynarepagul256]

Can't apply rows in conditional formatting

[@foroutarpitsingh8126]

vlookup se kaise krege...plz tell

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

[@umeshgajjar1908]

Nice

[@Innozant]

Thanks Umesh..❤️

[@rajeevdubey2668]

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

[@bikashkumarparida7595]

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

[@jaynandangiri4401]

But ye Sumifs bhi to kar skte hai

[@Innozant]

Yes . Kyu nahi

[@AbhishekKumar-nb4et]

Sir isme confidential f. Me

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

[@sunnykhowal3311]

Sir exel b dedo practice k liye

[@Innozant]

Wo to download kr lijiye..

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

[@shwetkumar1719]

vlookup se kaise krege sir?

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

[@NeerajKumar-hd1km]

Sir, can we sum from May to Aug month

[@Innozant]

Yes we can..need to make both range dynamic

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

[@aqeelahmadengr3]

Liked

[@Innozant]

Thanks

[@atulgoodify]

When I see your video everything looks fine but in reality not. आप कैसे इतने एक्सपर्ट बने

[@Innozant]

❤️❤️

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

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

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

[@anandsinghrawat6397]

Gazab sir gazab but sir ye vlookup se nahi ho paa raha hai

[@Innozant]

Aapne attempt kiya vlookup se.?

[@anandsinghrawat6397]

@@Innozant ji sir kiya tha meine

[@premchandraroy7174]

Sar index jab ek hi raw aur colum