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

Подписаться 154 тыс.

Просмотров 82 тыс.

50% 1

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.c...
(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

Опубликовано:

4 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 142

@cartoonloversop6019 3 года назад

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

@Innozant 3 года назад

Hahaho.Thanks...Happy learning

@harmeetbedi2627 Год назад

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

@asharfali9029 2 месяца назад

Sir koi aisa jugad hai ki hum kisi row enter kiya hua naam sheet par dynamic update ho

@tarun_k_shorts 3 года назад

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

@Innozant 3 года назад

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

@shubhamsharma2067 4 года назад

Best Playlist of MS Excel Ever on the RU-vid Plateform...Thank's ..!!

@Innozant 4 года назад

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 4 года назад

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

@surajitmaji1348 3 месяца назад

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

@Innozant 3 месяца назад

Thanks keep growing

@khizar6664 2 года назад

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

@Innozant 2 года назад

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

@TariqAli-ro4ko 4 месяца назад

No words...splendid

@narottammanihal8463 Год назад

अति सुंदर

@kinghundred 3 года назад

very great sir

@Nadeemahmed.1234 2 года назад

Wow wonderful sir

@Innozant 2 года назад

Thanks dear

@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 Год назад

😊👍❤️

@shashankku.1469 2 года назад

Best Vlook up series in You tube!

@Innozant 2 года назад

Thanks Shashank Ji

@devokedevtech2750 2 года назад

excel superstar 👌👌

@Innozant 2 года назад

❤️❤️❤️

@PradeepKumarSingh Год назад

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

@Innozant Год назад

Thanks Pradeep Ji

@gajananrewale4169 Год назад

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

@Innozant Год назад

Thanks dear

@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

@kalyani.9354 3 года назад

Excellent sir

@Innozant 3 года назад

Thanks

@ManishVerma-gg8xl 3 года назад

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

@Innozant 3 года назад

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

@devendergusain8974 3 года назад

ati uttam

@Innozant 3 года назад

👍👍❤️❤️🙏

@tusharpawar3557 3 года назад

Nice Sir aur Aapki play list totally use full hai 🙏

@Innozant 3 года назад

Thanks Tushar Ji❤️🙏 HV a nice day

@krishan_kumar_64 Год назад

Thank you so much

@pankubisht3495 3 года назад

Great sir

@Innozant 3 года назад

❤️🙏

@farooqA143 2 года назад

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

@Innozant 2 года назад

Thanks Farooq 👍❤️

@yatharthyagya7675 Год назад

awesome information

@marutipatil6399 2 года назад

great 😘

@archanarudra432 Год назад

Thankyou so much Sir

@Innozant Год назад

Thanks Archana👍

@bhoopendraraghav9781 4 года назад

Very nice sir

@Innozant 4 года назад

Thanks Bhoopendra

@shaikhrahima4512 9 месяцев назад

Thanks sir

@forestcraft9997 Год назад

thank you for this formula

@amandeepbadgujjar7096 11 месяцев назад

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

@Innozant 11 месяцев назад

Thanks

@dhakafady774 Год назад

thanks a lot

@alokpal7352 3 года назад

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

@Innozant 3 года назад

Thanks Alok Pal❤️🙏

@zahoorsarbandi2982 3 года назад

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

@Innozant 3 года назад

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

@dhananjaymangalore6934 2 года назад

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

@Innozant 2 года назад

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

@DEviL-sp4uy 4 года назад

Ek number sir

@Innozant 4 года назад

Thanks Dear, Happy Learning and share with your friends

@kinghundred 3 года назад

very excellent sir

@sandeepaswal8944 4 года назад

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

@Innozant 4 года назад

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

@jyotiparida1807 3 года назад

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

@Innozant 3 года назад

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

@swagatamkhanra4667 3 года назад

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

@Innozant 3 года назад

Thanks dear..God bless you

@Excel_experiment Год назад

Please make video on vlookup match with conditional formatting

@tarunsehgal5789 3 года назад

Thanks sir, well explained.

@Innozant 3 года назад

Thanks Tarun ji❤️🙏

@K-Starreaction 2 года назад

Thank you!!

@kanchanyadav1240 3 года назад

nice video

@Innozant 3 года назад

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

@pawanwakale8801 2 года назад

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 2 года назад

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

@pareshparikh7944 4 года назад

Great work sir

@Innozant 4 года назад

Thanks Paresh ji

@aakankshasrivastava9497 4 года назад

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

@Innozant 4 года назад

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

@vinayrsoni4334 3 года назад

Nice

@Innozant 3 года назад

❤🙏

@qblakesnappit 3 года назад

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

@Innozant 3 года назад

Thanks dear.. happy learning

@paramjeet975singh3 4 года назад

nice

@Innozant 4 года назад

Happy Learning

@mrpradosh5591 3 года назад

Thanks sir 👍

@Innozant 3 года назад

Thanks 🙏❤️

@gauravbhatia7987 3 года назад

Thnq

@Innozant 3 года назад

Thanks Gaurav Ji👍🙏❤️

@virendersroha1754 4 года назад

Vlkup+ match Index+ match Ye dono osm function h

@Innozant 4 года назад

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

@virendersroha1754 4 года назад

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

@sudiptamanna4195 3 года назад

ITS MORE POWERFUL ... INDEX WITH MATCH SABSE BEHETAR

@Innozant 3 года назад

Thanks Sudipta🙏❤️

@rameshbhuva2668 2 года назад

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.

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

@सिंघोड़ा 2 года назад

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

@rishabhgupta9431 2 года назад

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

@Innozant 2 года назад

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

@artfun7907 2 года назад

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

@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

@anuragmahendratiwarivad2012 3 года назад

Sir we can use date formula to connect with vlookup

@akshayverma7477 7 месяцев назад

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

@tejpalsain1507 4 года назад

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

@Innozant 4 года назад

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

@RaghavTechnical671 3 года назад

Sir excel main VBA and access ki video kab start karenge

@Innozant 3 года назад

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

@a.g.systemsaurangabad1543 3 года назад

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

@Innozant 3 года назад

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

@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

@sumitpedgaonkar4707 2 года назад

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

@satishojha6240 4 года назад

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

@Innozant 4 года назад

My favourite is index but vlookup is more optimized

@raghusist 3 года назад

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

@Innozant 3 года назад

again using index match..

@sangeetabandelkar524 3 года назад

How to round 2 decimal in pivot table

@Innozant 3 года назад

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 3 года назад

@@Innozant thanks

@ramashankarverma246 2 года назад

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

@Innozant 2 года назад

Kuch galati kar rahe hain..check again

@PRASHANTSINGH-is9bs 8 месяцев назад

Sir ,Awaz nhi hai video mai

@Harish.Prasad.Semwal 8 месяцев назад

1:48 2:39 7:53

@joydeepdey9891 3 года назад

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

@Innozant 3 года назад

Freeze karte hain F4 se dear

@travellergroup5139 2 года назад

Sir mere formula lagane par #n/a aaraha hai

@Innozant 2 года назад

#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 3 года назад

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

@nasirali4016 Год назад

Sir you are so fast

@Innozant Год назад

Ok..Noted

@avinashbudhraja6392 2 года назад

bored.....dhang ki example lo

@Innozant 2 года назад

🙏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..🙏♥️