Vlookup with Match Function

VLOOKUP MATCH is an improved version of your basic VLOOKUP formula. Using VLOOKUP with MATCH allows you to perform a matrix lookup, instead of just looking up a vertical value. MATCH portion of the formula turns your column reference into a dynamic horizontal lookup as well.

[@piyushrana1242]

thank you sir kafi time s preshan tha m collection office m bacho ka feedbck update m bht problem hoti thi bar bar vlookup lgane s ab shi h thanks you soooooo much sir

[@santoshkumar-rd2ws]

Amazing bro

[@atulgoodify]

Nice effort as you are showing real life situation

[@maheshwaghmare6931]

its working sir...very properly..very useful...amazing trick..all videos very useful..

[@sp7659]

Awesome work Amitji. Thanks a lot.

[@kapilgarg1747]

Thank you so much, Excellent job, very helpful video for everyone

[@learne-excel5365]

Really nice video

[@vibhutiagrawal579]

Sir You are great. Keep uploading videos regarding excel formula. It's really very helpful. Thank You Sir

[@rivayettv7265]

You are great Keep it up the good work

[@raghubabu5312]

Ur videos very useful keep different types of Excel formula videos thank you very much dud

[@prashantjoshi942]

you are doing great job...
keep it up...
thank you very much

[@fintaxprime]

Your welcome sir...

[@rahulpagaria4790]

Really helpful as usual your all videos great job

[@fintaxprime]

Thank you....

[@surinderranjan6431]

Bahut achhha hai

[@dharmendarrana4191]

Very good sir

[@maheshwaghmare6931]

I had tried with different data it is working..

[@KaileshHambireIJ-G-]

Excellent Mr Genius, Trying to rewind your old videos so that I can understand your current videos much better. Thanks for this basic video. I request your followers to watch your every video in this channel. Thank you once again. Kailesh hambire ( A.M.I.E , Chartered Eng ).

[@fintaxprime]

Thank you brother for your appreciation and support.

[@rahulsahu6709]

You:- कैसा लगा आपको फार्मूला?
Me:- जोरदार, जबरजस्त, ज़िंदाबाद👍🏻👌🏻🙏🏻😇

[@gauravtyagi5816]

Good explained .

[@shivinsharma8594]

Very helpfull content (Y)

[@sumitdhiwar7502]

Sir, Thank a lot...!

[@amit_6676]

You are fabulous Teacher

[@fintaxprime]

Thank you so much for your kind words! I am humbled and happy to help!

[@ajeetpathak9667]

Thanks for your video's

[@satishvspu]

Great video and very useful in office work. Thanks

[@fintaxprime]

Thank you for liking my Video. Yes this technique will not only work for 2A reco, it may work for many different type of reconciliations.

[@ParshuramRampurkar]

@@fintaxprime Sir, While doing GSTR2A reconciliation, I want to apply like " Less in GSTR2A Or Excess in GSTR2A " for Data Sheet
How can I apply? Can you help me
My mail id is [e-mail]

[@nitinsudrik9175]

excellent

[@wrongturnlima007]

Very nice

[@sumitdhiwar7502]

Sir, Thank a lot ......

[@DilkiaawazAnita]

Very useful

[@RajeevKumar-iq6rl]

You are the best...

[@fintaxprime]

Thank you for liking my Video.

[@only4technical722]

Nice....used full.

[@gauravtyagi5816]

Thanks sir Can we get one video using $ sign in multiple use with Index + Match function also.

[@ShriShyamSumiran]

Sir Thanks for this vedio
Please make a video on 3b adjust in books by gst portal

[@khalidmajeed2886]

magic-------

[@calalankumar5738]

Nice 👌

[@bharat4891]

Fabulous Sir

[@fintaxprime]

Thank you....

[@Am_Karthik]

good its helpful

[@arjunsingh1811]

Thanks Jain Sir GST 2A Match bhi vlookup se Bataye kar sate hai kya ?

[@basavarajmadari8627]

Thak you sir

[@RaviGupta-zo8ev]

Sir, please make a video on transfer pricing practical case

[@akshaysharma6702]

Great

[@aaayusharmaa]

please give video on multiple look-up value.

[@RajeevKumar-iq6rl]

Thanks.....

[@fintaxprime]

Thank you for liking my Video.

[@atulgoodify]

Looking good but display no clear

[@tarunkumarreddy9888]

🙏💕🙏💕🙏💕🙏💕🙏💕

[@neerajrawat4288]

Sir ye formula horizontal mein work nhi kr raha hai
Can you give me advice

[@p.narasimamurthy5353]

Name matching in excel utility version3 of unmatched bill numbers side by side rows

[@arunkumardhiman2871]

Agar sir colam same na ho toh fir kya karenge

[@sonijaiesh]

good brother

[@fintaxprime]

Thank you for liking my Video.

[@rajeshshere618]

Sir how to find grator than value in vlookup

[@amit_6676]

Please share the sheet for Practice

[@kavitachauhan8554]

sir, please vlookup ke formule se gst r2 ki reconcilation ki video bnana

[@sushilsharmahr0835]

Sir aap jo example seet used karne ho to vo description me de diya karo

[@manpreetsingh6736]

Sir work ki practice k liye long sheet kaha se download kre

[@sameerdeore4225]

Sir
Agar aap jise fix karana chahte ho vaha pay edit karke F4 press karenge to dollar apane aap lag jayega apako aage piche karne ka time save ho jayenge

[@calalankumar5738]

😃😃😃

[@apoorvashah5883]

Hi .... Can you please share data sheet for excercise?
Thank you

[@fintaxprime]

Thank you for liking my Video. Due to heavy demand, and time constraint, I have uploaded utility on below link. Please down load the same from here.
www.dropbox.com/sh/wbmpah1r2fz8gpz/AADlAALR4xWKvfcC_2KoHUZ5a?dl=0

[@caprempandey2801]

Sir Jo aap Dummy data ki Excell sheet banate hai usko aap neeche link de diya kare jisase same data me ham log bhi practice kar sake. other wise ham log concept to samajh lenge par practice kar k same result nahi la payenge.
Reply

[@fintaxprime]

Hi Prem, you will find the same in my latest videos wherever its required however yes in my old videos it might not be available

[@surenderyadav1991]

Hi sir

[@maheshwaghmare6931]

i tried step by step it is not working properly sirji..pls help

[@fintaxprime]

Hope it is working now as I can read in your another message.

[@p.narasimamurthy5353]

Sir you forgotten pls share the tricks

[@fintaxprime]

Which tricks?

[@abdulmokheem1820]

Not understand

[@sameerdeore4225]

Sorry agar aap ko bura laga ho to