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.com/drive/folder...
(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

[@maddy2613]

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

[@RajGopalPandit]

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

[@nishan20081]

I like the way you teach in detail

[@blackrose6817]

Sir Apka explanation bohot accha❤❤❤

[@balakumaran75]

Nice conditional formatting trick. Thank you

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

[@user-ej9pz5zd5i]

Outstanding...

[@asimali5820]

Wonderful!

[@sujoysarkar5406]

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

[@Innozant]

Thanks Sujoy❤️🙏

[@saiyadazazali3243]

superb all excel video

[@curious1245]

Thanks for this video. Great.

[@Innozant]

Thanks Amit Happy learning

[@kanchanyadav1240]

Thank you for updating my knowledge

[@Innozant]

Thanks Kanchan ji

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

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

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

[@anilrajput6497]

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

[@Innozant]

Thanks dear...Happy Learning

[@superNareshg]

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

[@Innozant]

Thanks dear

[@akak3585]

Thank you sirG

[@bhoodevbasicinformation]

very good
Great Video

[@shahzadsiddiqui5117]

very very very good..!

[@ROHITKUMAR-te9pk]

Very good logic

[@tejpalsain1507]

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

[@Innozant]

Thanks Tejpal dear...

[@kinghundred]

very excellent sir

[@deepnarayandubey2383]

You are real excel guru

[@Innozant]

Thanks Deepnarayan❤️🙏

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

[@gauravbhatia7987]

Thnq sir bohat bohat thnq

[@shaileshkumar-qf6bd]

Than you so much sir

[@RohitKumar-cc7zi]

Very good way to teach, awesome

[@Innozant]

Thanks Rohit Ji🙏❤️gn

[@brijeshshah574]

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

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

[@bishtlokesh1297]

Awesome topic useful topic for excel users

[@Innozant]

Thanks Lokesh..hv a nice day

[@bishtlokesh1297]

It's so good ❤️

[@Innozant]

Thanks

[@naeemkhan-tm9hx]

Zabardast...MashaAllah

[@Innozant]

Thanks .. dear..Gn

[@satishmestry5687]

Very nice sir.
informative video.

[@Innozant]

Thanks dear🙏❤️

[@jamalibrahim3229]

amazing!

[@Innozant]

Thanks

[@msexcelgooglesheet374]

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

[@Innozant]

Thanks 😊🙏

[@RakeshSingh-qo5nd]

Ur teaching style is amazing bro

[@Innozant]

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

[@prochallengers8920]

thank you sir...

[@Innozant]

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

[@secretkingstatus9343]

Sir bahut hi badiya video thi maja aa gya

[@Innozant]

Thanks dear

[@hemantgusain1260]

Really helpful video for interview prospectus.

[@Innozant]

Thanks Hemant ,is topic ke 3 video aayenge abhi

[@hemantgusain1260]

@@Innozant ok sir

[@jaspalrana9541]

Amazing 👌

[@Innozant]

Thanks Jaspal Ji.

[@mrsswetakumari8089]

excellent sir 👌👍

[@Innozant]

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

[@ajinkyashinde1778]

Excellent 👍👌👌

[@Innozant]

Thanka Ajjnkya Ji.,🙂

[@VikramKumar-du2mw]

Mast Sir 👌👌👌👌

[@kirtisharma2373]

😊Great....

[@Innozant]

Thanks Kirti

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

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

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

[@manishkumarpingolia393]

Very nice 👍

[@Innozant]

Thanks Manish Ji👍❤️

[@Jitenderkumar-yp1rn]

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

[@Innozant]

😊👍

[@rahulrakshe1988]

Nice

[@saahilsaahil5912]

Amazingggggggggggg👌👌

[@Innozant]

Thanks

[@surajrajput2752]

Congrats sir g add mil gya aapko👍

[@Innozant]

❤️😂

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

[@bhoopendraraghav9781]

Wow very nice.

[@Innozant]

Thanks Bhoopendra..Gn

[@bhoopendraraghav9781]

@@Innozant gn sir g

[@RamSingh-ol5xz]

Nice 👌

[@Innozant]

Thanks Ram

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

[@devokedevtech2750]

Super sir

[@Innozant]

Thanks Dheeraj ji

[@nadeemahmed8762]

Sir. Bhot aage jaenga aap UA-cam pa.🔥♥️.aisa hi video banate rhe🔥

[@Innozant]

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

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

[@aqeelahmadengr3]

Liked

[@Innozant]

Thanks

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

[@SouravKumarRoy651]

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

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

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

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

[@rajeevdubey2668]

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

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

[@user-mw6xf3ky9e]

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

[@AmitKumar-xi3oe]

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

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

[@Harish.Prasad.Semwal]

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

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

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

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

[@vikkynarepagul256]

Can't apply rows in conditional formatting

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

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

[@shadab917]

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

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

[@sunnykhowal3311]

Sir exel b dedo practice k liye

[@Innozant]

Wo to download kr lijiye..

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

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

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

[@amitpyasi2819]

Please sir uploaded video office 365

[@Innozant]

Soon we will start office 365 series

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

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

[@shwetkumar1719]

vlookup se kaise krege sir?

[@NeerajKumar-hd1km]

Sir, can we sum from May to Aug month

[@Innozant]

Yes we can..need to make both range dynamic

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

[@Altaf_Alam]

Sir sum ko pehle range ka pehla reference mil ja raha b2: phir iske baad jab hum index lagate hai tab index hame value hi lakar toh deta hai sales ka .... Toh ye sum ko reference kaise mil ja raha index ke sahare ? Plz reply sir internally kya ho raha agla reference kaise mil raha sum ko

[@premchandraroy7174]

Sar index jab ek hi raw aur colum

[@jaynandangiri4401]

But ye Sumifs bhi to kar skte hai

[@Innozant]

Yes .
Kyu nahi

[@chootuthakur2776]

Sir 2nd question- sum(B2:vlookup(d2,a2:b13,2,0))
Enter karne ke bad error aa raha h

[@snehapandey2816]

Sir please solve this with vlookup

[@Innozant]

Sneha Vlookup se to naur easy hai..ok yaad dila dena kisi aane wale video series me add kar denge.🙏❤️

[@snehapandey2816]

@@Innozant =SUM(VLOOKUP(A6,$A$8:$D$10,MATCH(A6,$A$7:$D$7,0),0))
=VLOOKUP(A6,SUM($A$8:$D$10),MATCH(A6,$A$7:$D$7,0),0)
=VLOOKUP(A6,$A$8:$D$10,SUM(MATCH(A6,$A$7:$D$7,0),0))
Sir ye 3 menthod try kiya ab aage samjh nahi aa raha hai, please aap formula he edit kar de baat main samjhne ki kosish kar lungi . Thank you.

[@sanjaykumarteli1537]

Sir थोड़ा सा zoom कीजिए na.