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

VLOOKUP with MATCH Function in Excel | How to use MATCH Formula with VLOOKUP 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-Match2.xlsx)
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#matchformula #vlookupwithmatch #Innozant #Exceltutorial #vlooukpmatch

[@basantakumardakua8811]

What a nice presentation sir ! Mind blowing . Your all videos are Very helpful to me thanks a lot.

[@Innozant]

Thanks dear.God bless You

[@RajGopalPandit]

Nicely explained. I at the age of 73 practicising on your vlookup videos enthusiastically. God bless thee.

[@Innozant]

Wow..Really great sir.Keep learning

[@sairaaslam3292]

Nashtay k foran baad apki vedio ...ufffff itna khubsurat andaz k mujhe jaisi kum parhi likhi bhi samjh gai hai ...
Students nalaeq nahi hotay ...teachers ko " samjhnana ana chahiye"
Itna friendly or dimagh ko samjh k samjha rahe hain ap ..behad shukriya

[@Innozant]

Thanks Saira.Good Morning,Aapke last comment ka maine reply kiya hai use padhiye aur uspe kaam krna start kriye..❤️❤️Thanls Innozant Family ka valuable asset banne ke liye..God bless you..❤️🙏

[@rafatali6058]

Really Sir your teaching method above superb...
God bless you with your fmly

[@sandeepaswal8944]

Sir hlookup with match bhi solve kar diya. Vlookup & hlookup with match clear concept samaj aagaya hai. Daily I practices ur all videos 7hours. Interest badta hi jara hai mera aab.aur confident leval bhi. Thank you so much sir ji. God bless u.

[@Innozant]

Good Sandeep..Keep it up

[@scientistsingh1517]

Apka Excel video dekh dekh ke me aaj MIS ka job karta hu ,,, bhaot bhaot dhanyavad apka sir ji

[@Innozant]

Congratulations ❤️

[@KiyaniPlateOfFlavour]

❤tremendous way of the teacher inspired

[@kalavathyr4003]

thank you very much for your effort and especially for uploading practice files

[@Rohith_08]

Superb explanation bhayya🎉🎉

[@pawansharma-ij7kg]

Sir, I appreciate your efforts. Very Nice Explanation in each video. Now, Excel is becoming a very easy tool for data modification and analysis.

[@Innozant]

Thanks Sharma ji for yout valuable appriciation dear.Really means a lot to me❤

[@Nadeemahmed.1234]

Great knowledge

[@surajrao9193]

Dear Sir,
Thank you so much because of you I'm working now as a MIS Executive in Teamlease. I have learnt advanced Excel by watching your videos.

[@Innozant]

Thanks Suraj ,Have a wonderful career ahead ❤️

[@PuranKumarBhuwanta]

You are amazing sir... thank you so much

[@deepankarmajumdar4713]

Your videos are really important sometimes thanks buddy

[@sujitsk]

Super! thank you 🙏

[@aakankshasrivastava9497]

Done Sir...Thanx for d another examples now vlookup+match concept is clear.

[@Innozant]

Good Aakanksha,It seems you start practice on daily basis..Your hard work paid off soon...Happy Learning.

[@nazrukhan2111]

Excellent work 👍👍👍

[@yahyavohra1861]

Very interesting way of explanation

[@gourabghosh4274]

I have never seen any better teacher than you in youtube♥️♥️♥️♥️

[@Innozant]

Thanks Gourab ji..Happy learning ❤️

[@namratatrivedi4055]

Thank you so much for help

[@jaynandangiri4401]

Kya Explanation hai Sir.bahut mza aaat hai video dekhne me... sach me

[@Innozant]

Thanks dear .Really means a lot to me

[@jaynandangiri4401]

@@Innozant Maine Lookup ka function ka use kiya tha jo apne batayaa tha Hiring wala example but data wrong number me rahe hai date show nhi kar raha haj jabki date me convert kiya hai

[@bhaktisagar0892]

Good Afternoon sir, aapke videos se bahut kuchh sikh raha hoon aur sabse badi baat jaldi sikh raha hoon kyonki concept bhi clear ho raha hai
Thanks sir

[@Innozant]

Thanks dear❤️👍

[@amit.k4012]

Kya mast samjaya bhai. This is what I wanted.

[@Innozant]

Thanks dear

[@ManojKumarBaghel1432]

Guru ji,
Itna clear koi nhi btata hain free main.
You are a great. Aapse milne jaruru aaunga job lagne ke baad.

[@Innozant]

Thanks Manoj Ji .God bless You .Happy learning dear

[@Radhe.mahant2010]

No any others in youtube like you

[@Innozant]

Thanks dear ❤️

[@rajdeepsaha9059]

Outstanding Interpretation.There is a another channel in UA-cam which talks about excel name "Leila Gharani" highly recommended channel.You are the only man who can compete to "Leila Gharani".Your logic and Leila Gharani's logic are quite similar.

[@Innozant]

Thanks Rajdeep for your valuable appreciation..Happy learning.

[@dhakafady774]

thanks a lot

[@alishachautala9482]

Sir ji you are mentor thank you for giving such information 🤗

[@Innozant]

Thanks dear

[@user-hz7qx2ns5w]

Amazing video sir

[@manjit.sarania]

Thank you sir

[@satishmestry5687]

Nice explanation.
Thanks Sir.

[@Innozant]

Thanks Satish ji

[@sujon44]

your knowledge on Excel, as well as your teaching method are outstanding . No doubt.
we have received lots of method from your tutorials and applied in the practical field. Boss, please provide us all of your tutorials practice file. it would be more helpful to make practice. your prompt action in this matter will be highly appreciable. please keep in your mind our request .

[@Innozant]

Dear..go to any recent videos description..You may find there direct link of practice file Playlist wise.
and seprate link for practice file used in videos.
happy learning dear...❤❤🙏🙏

[@suryanarayandas4978]

Thanks you sir❤

[@knowledgeandwisdom1584]

Impressive efforts and wonderful way of teaching . I really appreciate your efforts and would encourage you for your work. Please continue with your channel as you have been blessed with skills required ... Thumbs up bro

[@Innozant]

Thanks Khan sahab for your valuable appreciation ❤️

[@satishojha6240]

Thanku sir for simple and very useful function vlookup and match we are waiting for next video on tomorrow gn.

[@Innozant]

Thanks Satish..Gn

[@rajcomputertiloi3080]

Very important video sir aise hi video banana sir

[@yogeshmishra7780]

Jaisa ki pahale hi kaha, mazedar insaan aur teacher 😊 Naman

[@Innozant]

Thanks

[@rhashmi1]

Very nice.

[@sanjaysingh-wf6os]

Great explanation and very helpful for me .

[@Innozant]

Thanks Singh Sahab❤️

[@kinghundred]

very great sir

[@sailraza5940]

❤❤❤❤❤❤ buhat shkriya

[@kanhaiyakavathekar9058]

Thank You Sir ji

[@ramakar3847]

Thank you so much sir.
Apke guidance k bajah se ajj main computer exam pe pass huya hu.
Thanks a lot sir. Mera pranam lijiyega.

[@Innozant]

Thanks Rama.God bless You dear..Keep Learning ❤️

[@rohitag884]

You're really great and helpful, thank you so much!!

[@Innozant]

Thanks Rohit ji.have a nice day

[@rohitag884]

@@Innozant You're welcome sir, abhi aap ki hi rand function wali video dekh rha hu, love you sir

[@rohitag884]

You too have a nice day

[@Innozant]

Are wah..Seekhiye step by step ..have a great day

[@sumantadas1521]

Great Sir❤

[@josephkarottu4166]

excellence presentation

[@Innozant]

Thanks Joseph❤️🙏

[@rajeevpal2768]

Sir, yau have made my work easy. thanks a lot sir.

[@Innozant]

Thanks Rajeev Ji. Happy Learning ❤️

[@SusmitaMelodies]

Very helpful sir

[@Innozant]

Thanks

[@MansiSharma-cp8yo]

Sir you always explain the concept very well

[@Innozant]

Thanks Mansi..Really means a lot .

[@KamalSingh-so6mk]

U r great sr🙏🙏🙏

[@Innozant]

Thanks Kamal

[@akashprajapati6635]

Great work sir🙏😌🥰

[@Innozant]

Thanks Dear

[@gautammishra6395]

Nice video sir and teaching method is so good 🤗

[@vanistajames346]

Wow amazing!!!Today I've learned something new in this video.. Great work sirji ☺

[@Innozant]

Thank you so much Vanista.Keep Learning

[@ritikamahajan3839]

Too good sir

[@kalyani.9354]

NICE SIR JI
VERY GOOD INFORMATION

[@Innozant]

Thanks Shashikant Ji.God bless You

[@anowarhossainchowdhury]

ماشاءاللہ بہت خوب

[@meditationmusic6482]

So nice Sir ji 👍

[@Innozant]

Thanks Sanoj

[@its2vibhor]

if index + match formula will work mith merge columns .

[@virendersroha1754]

Nice

[@RahulYadav-yt4jn]

Good Afternoon sir 🙏🙏🙏..I have learnt a lot from your videos.I have one question how can I use doller sign to absolute cell in excel using shortcut in Laptop. I know in Desktop/Pc using short f4.

[@sumanmukherjee4710]

Vlookup ke saath kon sa function use kare column, columns ya match. Which the best combination?

[@gauravbhatia7987]

Good

[@sudeshprajapati5663]

How can we match two excel sheet data. Such as matching two bank statement!!

[@Damien1_1]

Thank you but why are you freezing the arrays? Even if we want data for other days, the DRAG-down should work here without freezing cells

[@rizwanmustafa4351]

Hello, isi ma agr designation ki base py name utha k lana ho to wo kesy laen gy ..???

[@thinkbyrehan]

such a long time to do this, i faild so many time but finaly succcsed of this table with one buy one plz ignore english mistek recently i stated english i had never gone single time schoole

[@RBoro-fu5gz]

Sir last mein control D ke baad control kya..... press karna hai

[@gurpreetkaur-zr1qj]

TY

[@Innozant]

Thanks Gurpreet...Keep learning ❤️😊

[@manthanverma.756]

Sir vertically freeze ke liye 2 times F4 and horizontally freeze ke liye 3 times F4. Then sir surf 1 column ka data aata h baki N/A aata h.

[@nasirali4016]

What a genius and charming personality you are wish you are Muslim

[@Innozant]

Thanks Nasir..👍

[@MdShafiurRahman]

Sir ek vedio banaye jisme excel ke though automatic school routine bana saken

[@madhujitrana9416]

Sir, if row a and b contain data like -multiple duplicate date and multiple duplicate name with qty, and second sheet contain same data then how to look up and get quantity in sheet 1 from sheet 2

[@Innozant]

Duplicate lookup using countif try to gind unique occurance of dataset then apply lookup to extract data from 1st sheet

[@madhujitrana9416]

Sir here has any video.??

[@bhramanti4152]

if u select column directly it will give u the same results in vlookup with minimum efforts so why dobu want to have match beded in vlookup... pl if u can explain this concept....

[@Innozant]

Great,..and what if we have number of columns from where we want to extract non continuous column data?

[@bijayadhikari1612]

Sir jese ki class 1 ke student kaa roll no or class select karne se student name aane wala formula batadjiye naa vlook up jese please

[@professor3576]

Sir what is the key to freeze cell in MS EXCEL 2007 Version?

[@Innozant]

F4

[@Unfiltered_ind]

Sir ye index +match+match se bhi solve ho jayega ....

[@Innozant]

👍❤️

[@someonefrom2002]

7:32 sir aapne toh kuchh jyada hi madad kr di 😆😆😆😆😆

[@Innozant]

Hahah..samajh aa gya ki madad krna chah ra hu...laga tha na pura hint milega???apko😀❤️

[@someonefrom2002]

@@Innozant 😆😆😆

[@AbhishekKumar-nb4et]

Sir mai interviewe ke liye gya tha usme sir apne live data par hi de diya vlookup ka question sir data bahut bada tha name ke base pe email I'd , number aur do teen information Lani thi alag workbook pe to sir Maine vlookup use kiya to data etana bada tha ki sir selection to kar liya jab match lagaya tab sir usme usme sir gadbad ho gya q ki data bada tha confusion me gadbad ho gya sir esko kaise short out kare?????? Ki jaldi se results la de

[@dikshagupta5703]

Sir apne video mein 10 min pe ek shortcut key bola hai can u please tell that shortcut and the use of it otherwise entire video I have understood so well ..thanks a lot sir for such wonderful explanation.

[@Innozant]

Hi Diksha,Good Morning
Freeze ke liye F4 bola hai aur fill down-ctrl+d fill right-ctrl+R
Step by step in sequence seekh rahe ho na aap?samajh aata hai concept.. Practice bhi karna hai alreday assignment diye gye hain ok.

[@rajansharma4591]

Sir you say you freeze range, how do we do that?

[@Innozant]

Usimg F4

[@sudiptamanna4195]

SIR VBA PROJECT EXCEL SIKHNA HAIN 2007 EXCEL MAIN KYA WORK KAREGA

[@Innozant]

Phirse puchiye .kya chahte hain aap?

[@firdausansari9879]

Sir,i like your teaching way but mujhe Samajh nhi ata ki kaun si row aur column kb, kahan and kyun freez karni hoti h
Please explain it🙏

[@johndas8173]

Sir multiple match vlookup if formula video combo formula

[@manishsah7629]

Last mai kya kiye sir ctrl d aur ctrl r

[@RajeshKumar-eh7vw]

Dear sir, please make videos on advance ms access.

[@Innozant]

Sure ,But now now after some time as Advanced Excel videos are uploading these days.Thanks for suggestion.

[@shivajibedre6756]

Hi sir,
Freeze Karne ke liye shortcut key Kon si hai?

[@Innozant]

F4

[@anantyesare3519]

Show Multiple Vendor Names Associated With Low Bid Array Formula INDEX

[@shwetkumar1719]

Sir esme hm match ka use kr ke 3 Lookup dekhe na ex-Name , Designation & Total Exp?
Lakin match ka to lookup value sirf "Name" Tha na?

[@Innozant]

Haan..output kya expect kr re the?

[@shwetkumar1719]

@@Innozant acha ha

[@shubhamdogra5386]

asli pyaar to index hai was 🤣 10:40

[@subhadiproy285]

Konsa button press Karke freeze Kia Apne.

[@Innozant]

F4
Basic excel playlist se start kriye seekhna

[@anandmishra756]

Lookup and array use krke bhi aasakta hai

[@Innozant]

Haan aa skta h

[@deepakchauhan4974]

sir ek hi master link hai , kisi kisi videos me do rahta hai, or wo practice set milta nahi hai

[@Innozant]

Dear Deepak.harek Playlist ka seprate folder hai aur link bhi (master and video link)

[@shantanudas8855]

Sir ji ek issue aa raha hai... Main jab bhi formula laga raha hoon toh last main bata raha hai " You have entered too many arguments for this function" . Yeh kyun hota hai? Please help

[@Innozant]

Galat paas kar re hain formula aap..parenthese miss kr re h..ya argument list complete nhi de re use

[@Harish.Prasad.Semwal]

7:44

[@virendersroha1754]

Sr jo vedio aap bnate. Ho vohe Excel ka link share kiya kro dhundne me prob hoti h

[@Innozant]

Virendra ji,Common link ke niche playlist ka naam hota hai saath hi filename.xlsx bus us folder me jake wo file download

[@virendersroha1754]

@@Innozant ok sr

[@alishekh3711]

Sir bahot hi der se is formula pe kaam kr rah hu pr ho nhi pas rha

[@alishekh3711]

Plz guide me

[@AbhishekKumar-nb4et]

Sir chote data pe to kar lete hai bade data pe sir gadbad ho jata hai sir bade data pe kaise use kare ki galti na ho? Selection me gadbad ho jata hai sir agar alag workbook pe Lana rahe to agar match laga rahe to Esme bhi selection karma hota hai to selection ka Naam bada ho jata hai aur confusion me gadbad ho jata hai

[@kingcinema5295]

how to freeze

[@Innozant]

Using F4

[@deepakverma5626]

Freeze kaise krte hai

[@Innozant]

Using F4 ..basic se seekhna start kariye

[@durgeshpratap5019]

Sir mujhe if sikhna h lakin if mujhe samjh me nahi a raha h please if funsion ka vedio share kare

[@mmnetworkandislamicstatus1248]

if function bahut asan hai bhai aap thoda brain lagao

[@Innozant]

Sahi se video dekhiye sequence me..it's very easy thanks learn