How to use VLOOKUP with MATCH Function in Excel | How to use MATCH Formula in Excel | 2D LOOKUP

How to use VLOOKUP with MATCH Function in Excel | How to use MATCH Formula in Excel | 2D LOOKUP
In this video you will learn #matchformula one of the most used exel function for Beginners or Advanced Excel users. This is very simple and interactive function in #excel which return the position of a lookup value from an array.It is even more powerful when we use match with other function like vlookup ,hlookup and most important with Index.
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.com/drive/folder...
(Playlist Folder-Excel Lookup Series-Match1.xlsx)
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#matchformula #vlookupwithmatch #Innozant #Exceltutorial #vlooukpmatch

[@cartoonloversop6019]

सर ये तो आप चीटींग🙏 कर रहे है
कयोकी मेने अभी बडी मुश्किल से Columns को सीखा है ठीक से प्रैक्टिस भी नही हो पायी है और अभी तक ROW or Rows के विडियो तक तो पहुंचा भी नही हु और आप यह MATCH ले आये 👌👌 Excellent

[@Innozant]

Hahaho.Thanks...Happy learning

[@harmeetbedi2627]

Thanks for teaching .. your way of teaching is very good ..🙏🙏 doing good work 👍👍

[@surajitmaji1348]

Dil Se, Thankyou, The way you are teaching is really unexpected... Sidha dimag pe ja ke baith ja raha hai...

[@Innozant]

Thanks keep growing

[@SKardam-ez1rt]

Sir aap bahut achhe se samjate ho Thanks 🙏❤

[@tarun_k_shorts]

Bap of all vlookup series in youtube 🔥🔥🔥 thnx sr

[@Innozant]

Hahahaha ❤️❤️❤️🙏😀😀Thanks Tarun Ji

[@shubhamsharma2067]

Best Playlist of MS Excel Ever on the UA-cam Plateform...Thank's ..!!

[@Innozant]

M really glad to listen this .. Thanks Shubham,It seems you analize no. Of chanels.Thanks a lot dear, Happy Learning
Recommend you to download the all Example workbook available in common link provided in Description
Playlist category wise.

[@shubhamsharma2067]

@@Innozant Yup , I am Daily Practicing It to Improve my skill , and get Confidence on My Knowledge .

[@khizar6664]

one of the best teacher in my life, love you ❤️💕💖💕
The concept is as clear as looking through a glass,

[@Innozant]

Thanks dear for your valuable appreciation..Happy Learning ♥️👍

[@sandeepaswal8944]

Sir You are best excel instructor A very informative and useful video. Appreciate your time and hard work to prepare this video.

[@Innozant]

Thanks Sandeep for wonderful feedback always from you..Keep watching ,Learn and share.

[@zahoorsarbandi2982]

Really fantastic, explained in a very simple and easy way. Very helpful for all age of people

[@Innozant]

Thanks Zahoor sahab for your value comment.. Happy learning..

[@K-Starreaction]

Thank you!!

[@TariqAli-ro4ko]

No words...splendid

[@forestcraft9997]

thank you for this formula

[@krishan_kumar_64]

Thank you so much

[@yatharthyagya7675]

awesome information

[@shashankku.1469]

Best Vlook up series in You tube!

[@Innozant]

Thanks Shashank Ji

[@dhakafady774]

thanks a lot

[@kinghundred]

very excellent sir

[@kinghundred]

very great sir

[@akak3585]

Thanks sir G

[@jyotiparida1807]

Thank you very much boss for your efforts to develop skills.

[@Innozant]

Thanks Jyoti ji👍❤️ happy learning ❤️❤️

[@SandeepSingh-nj4tf]

Sir... I really appreciate your style of teaching.
It's very unique quality you posses.
Very simple approach to teach..
I heartily offer a big big thanku sir....

[@Innozant]

Thanks Sandeep ji for valuable appreciation

[@shahzadsiddiqui5117]

this was i looking for, very very uselful function my seniors always used and i was unable to understand... now i can also this function like them...thanks sir..!Respect

[@Innozant]

😊👍❤️

[@PradeepKumarSingh]

Thank u very much sir 🙏, u explained the use of vlookup and match function very clearly.

[@Innozant]

Thanks Pradeep Ji

[@shaikhrahima4512]

Thanks sir

[@tusharpawar3557]

Nice Sir aur Aapki play list totally use full hai 🙏

[@Innozant]

Thanks Tushar Ji❤️🙏 HV a nice day

[@narottammanihal8463]

अति सुंदर

[@gajananrewale4169]

Sir, You are very good at explanation. Tanks a lot for making concept clear....

[@Innozant]

Thanks dear

[@shakeelahamad4920]

Very Nice Sir

[@tarunsehgal5789]

Thanks sir, well explained.

[@Innozant]

Thanks Tarun ji❤️🙏

[@marutipatil6399]

great 😘

[@Nadeemahmed.1234]

Wow wonderful sir

[@Innozant]

Thanks dear

[@archanarudra432]

Thankyou so much Sir

[@Innozant]

Thanks Archana👍

[@farooqA143]

I'm from Pakistan. Excellent Sir You're amazing.😍

[@Innozant]

Thanks Farooq 👍❤️

[@honeydeniel2188]

Thank you so much sir

[@Innozant]

Thanks dear

[@alokpal7352]

Nice explain sir... I learn lot of from your video...

[@Innozant]

Thanks Alok Pal❤️🙏

[@dhananjaymangalore6934]

अपनी बात दूसरो को 100% कैसे समझाया जाता है इससे बेहतर उदाहरण नहीं हो सकता .

[@Innozant]

Thanks Dhananjay..God bless You...Keep learning dear

[@devendergusain8974]

ati uttam

[@Innozant]

👍👍❤️❤️🙏

[@pareshparikh7944]

Great work sir

[@Innozant]

Thanks Paresh ji

[@kalyani.9354]

Excellent sir

[@Innozant]

Thanks

[@swagatamkhanra4667]

Nice video sir, it really extremely helpful for us ,, thank u dil se sir

[@Innozant]

Thanks dear..God bless you

[@aakankshasrivastava9497]

NICE SIR..PREVIOUS VLOOKUP+HLOOKUP EXAMPLE IS ALSO DONE WITH THIS METHOD.. THANK U

[@Innozant]

Good Aakanksha ,M really happy to know that all of you are doing practice on regular basis.Thanks

[@ManishVerma-gg8xl]

सर इस tutorial मे आपकी T-Shirt का कलर और पीछे Dashboard का कलर हुबहु मेच हो हो रहा है यदि ध्यान से देखे तो।
vlookup aur match ka combination बहुत शानदार लगा बहुत बहुत आभार सर आपका 🙏🙏🙏

[@Innozant]

Hahahaha..itna notice karte hain aap..😀❤️Thanks Happy Learning ❤️

[@pankubisht3495]

Great sir

[@Innozant]

❤️🙏

[@devokedevtech2750]

excel superstar 👌👌

[@Innozant]

❤️❤️❤️

[@amandeepbadgujjar7096]

Hii sir this match function is very awesome in place of Hlookup, columns, rows etc.., thanks sir👏👏♥️♥️ for this great content video 👍

[@Innozant]

Thanks

[@DEviL-sp4uy]

Ek number sir

[@Innozant]

Thanks Dear, Happy Learning and share with your friends

[@mrpradosh5591]

Thanks sir 👍

[@Innozant]

Thanks 🙏❤️

[@bhoopendraraghav9781]

Very nice sir

[@Innozant]

Thanks Bhoopendra

[@gauravbhatia7987]

Thnq

[@Innozant]

Thanks Gaurav Ji👍🙏❤️

[@vinayrsoni4334]

Nice

[@Innozant]

❤🙏

[@kanchanyadav1240]

nice video

[@Innozant]

Thanks Kanchan for your valuable appreciation.. Wishinv you wonderful career ahead❤️

[@RMKserve]

Sir can you guide me how to filter a specific Data range in Power querry editor mode and remove the othen data and keep only filtered data.

[@anuragmahendratiwarivad2012]

Sir we can use date formula to connect with vlookup

[@sumitpedgaonkar4707]

Sir, If the lookup value is ' 5 ' and in table array column values are present as 0-10, 10-20 then how to perform the Vlookup function
Please help me

[@pawanwakale8801]

Vloop using match , last me apne bataya ki Vloop kaise twist huya galat value aya aur jab explain kiya toh pata chala real me kya hidden reason tha , Thank you sir

[@Innozant]

Thanks Pawan...Hope aap saare concepts ache se seekh rhe hain..❤️

[@paramjeet975singh3]

nice

[@Innozant]

Happy Learning

[@qblakesnappit]

Wow ... Gonna try this to replace vlookup+hlookup ... Please make english translation ... Thanks

[@Innozant]

Thanks dear..
happy learning

[@Excel_experiment]

Please make video on vlookup match with conditional formatting

[@artfun7907]

i have two spared sheets one is called stock with price
and another is called calculator
in a stock sheet there is 3 columns category and sub category and price
that shows in calculator sheet in list form
i am not able to get a specific price of category and subcategory wise
ex fruit is category and apple is sub category and 100 is price
in calculator sheet fruit and apple are showing but how can i get the price of it
please help me............
looking to hear from you..

[@virendersroha1754]

Vlkup+ match
Index+ match
Ye dono osm function h

[@Innozant]

Abhi ye vlookup series bahut lamba chalega..Wait and watch step by step ....

[@virendersroha1754]

@@Innozant bilkul sr be sbri se wait krte h apki vedio

[@raghusist]

Sir, In this example if price and size are given, how can we find out which Pizza type it is...
Thanks...

[@Innozant]

again using index match..

[@a.g.systemsaurangabad1543]

sir Pls conf what to do if excel hang or size become large...

[@Innozant]

Large size ke liye sayd maine video bnaya hai ya interview cracker me solution btaya hua hai

[@rishabhgupta9431]

Respected sir... sir kya hum Hlookup ke saath match functions laga sakte hai kya??

[@Innozant]

Kyu nhi lga skate match ka kaam bus relative position btana hota h

[@rameshbhuva2668]

Sir agar meri 10 product hai usme se 5 selected product ka 30 days me payment aata hai to use 3% CD dena hai agar 30 days
Ke baad payment aata hai to NO CD to sir isme formula kis tarah se lageg.

[@sudiptamanna4195]

ITS MORE POWERFUL ... INDEX WITH MATCH SABSE BEHETAR

[@Innozant]

Thanks Sudipta🙏❤️

[@CreativeCorner-007]

Sir do u take excel tuition as well?

[@Innozant]

Yes..you may connect with Team Innozant or visit Innozant website for more details about upcoming batches

[@satishojha6240]

Sir vlookup aur index mai se kya jayada use kartey hai aap.

[@Innozant]

My favourite is index but vlookup is more optimized

[@RaghavTechnical671]

Sir excel main VBA and access ki video kab start karenge

[@Innozant]

Kuch time baad...pehle jo Playlist chal re hain power query and power pivot bi ye sab finish karte hain

[@jaleel2477]

match formula sirf value ke liye hi ya text bhi chalta hai (named table me, text cell ko ye N/A batata hai text cell ko bhi explain karo bhai.
t
t

[@akshayverma7477]

Sir ye apne match ko highlight karke ye 3 column dikha raha hai ye kaise dekha

[@user-vn6xo8lt5t]

सर खास डाटा को फंक्शन के द्वारा किसी टेबल में लोकेशन निकालना कैसे करेंगे

[@sangeetabandelkar524]

How to round 2 decimal in pivot table

[@Innozant]

Hi Sangeeta,If you wish to display values with '2' decimal places in the pivot view ,then you need to format the corresponding column in base table

[@sangeetabandelkar524]

@@Innozant thanks

[@ramashankarverma246]

sir maine same aap ka chart or same app ka formula use kiya pata nahi kyu NA show kar raha hai

[@Innozant]

Kuch galati kar rahe hain..check again

[@tejpalsain1507]

यू ट्यूब पर हमने match के बहुत सारे वीडियो देखें। सबमें ये बताया गया कि यह क्या काम करता है।
पर वास्तव में ये काम कैसे करता है। आपने ये बताया।
आपका बहुत बहुत धन्यवाद सर।

[@Innozant]

धन्यवाद तेजपाल जी ,दिल से ,
पढ़िए सीखिए और आगे बढिये जिंदगी में

[@Harish.Prasad.Semwal]

1:48 2:39 7:53

[@PRASHANTSINGH-is9bs]

Sir ,Awaz nhi hai video mai

[@joydeepdey9891]

Sir ap kiu f4 press karta ha.pls Ripley divya.

[@Innozant]

Freeze karte hain F4 se dear

[@travellergroup5139]

Sir mere formula lagane par #n/a aaraha hai

[@Innozant]

#na tab aata hai jab lookup value table array me naa ho..kindly check it

[@ekramhossain7014]

why don't you write large and small ?
Large ,small we can be done it by large and small

[@Innozant]

Kindly note that match is use to find out relative position either horizontally or vertically,But Large and small?

[@Rajxixix0108]

Kid says - Formula lagana hai
Legend says- Formula chalana hai

[@nasirali4016]

Sir you are so fast

[@Innozant]

Ok..Noted

[@avinashbudhraja6392]

bored.....dhang ki example lo

[@Innozant]

🙏Prabhu aisa maine kya Bore karne wala example Kara Diya..sayad aap Jadoo wale video dekhna chah rhe hain 😀
Is channel par in sequence in depth agar course karne ke purpose se aaye hain to hi seekhen,anyatha short ya Jadoo video ke liye bht saare channel uplabdh hain YT par.Sorry Dilse apko bore kiya uske liye..🙏♥️

[@SKardam-ez1rt]

Sir aap bahut achhe se samjate ho thanks 🙏❤

[@dhakafady774]

thanks a lot

[@kinghundred]

very great sir