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.
Пікірлер: 87
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
its working sir...very properly..very useful...amazing trick..all videos very useful..
Nice effort as you are showing real life situation
Sir You are great. Keep uploading videos regarding excel formula. It's really very helpful. Thank You Sir
Amazing bro
Really nice video
You are great Keep it up the good work
Awesome work Amitji. Thanks a lot.
Thank you so much, Excellent job, very helpful video for everyone
Ur videos very useful keep different types of Excel formula videos thank you very much dud
you are doing great job... keep it up... thank you very much
@fintaxprime
5 жыл бұрын
Your welcome sir...
Really helpful as usual your all videos great job
@fintaxprime
5 жыл бұрын
Thank you....
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
4 жыл бұрын
Thank you brother for your appreciation and support.
You:- कैसा लगा आपको फार्मूला? Me:- जोरदार, जबरजस्त, ज़िंदाबाद👍🏻👌🏻🙏🏻😇
You are fabulous Teacher
@fintaxprime
9 ай бұрын
Thank you so much for your kind words! I am humbled and happy to help!
Great video and very useful in office work. Thanks
@fintaxprime
5 жыл бұрын
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
5 жыл бұрын
@@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 parshuram009@gmail.com
Bahut achhha hai
Very good sir
Thanks for your video's
Good explained .
Very helpfull content (Y)
You are the best...
@fintaxprime
5 жыл бұрын
Thank you for liking my Video.
Very nice
Sir, Thank a lot...!
Nice....used full.
I had tried with different data it is working..
Thanks sir Can we get one video using $ sign in multiple use with Index + Match function also.
excellent
Very useful
Great
Thanks Jain Sir GST 2A Match bhi vlookup se Bataye kar sate hai kya ?
Sir, Thank a lot ......
Nice 👌
good its helpful
Sir Thanks for this vedio Please make a video on 3b adjust in books by gst portal
Fabulous Sir
@fintaxprime
5 жыл бұрын
Thank you....
Thanks.....
@fintaxprime
5 жыл бұрын
Thank you for liking my Video.
Thak you sir
magic-------
🙏💕🙏💕🙏💕🙏💕🙏💕
Sir ye formula horizontal mein work nhi kr raha hai Can you give me advice
Agar sir colam same na ho toh fir kya karenge
Sir how to find grator than value in vlookup
please give video on multiple look-up value.
Please share the sheet for Practice
Name matching in excel utility version3 of unmatched bill numbers side by side rows
Sir, please make a video on transfer pricing practical case
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
5 ай бұрын
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
good brother
@fintaxprime
5 жыл бұрын
Thank you for liking my Video.
Sir work ki practice k liye long sheet kaha se download kre
Hi .... Can you please share data sheet for excercise? Thank you
@fintaxprime
5 жыл бұрын
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
Looking good but display no clear
sir, please vlookup ke formule se gst r2 ki reconcilation ki video bnana
Sir aap jo example seet used karne ho to vo description me de diya karo
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
5 жыл бұрын
😃😃😃
i tried step by step it is not working properly sirji..pls help
@fintaxprime
3 жыл бұрын
Hope it is working now as I can read in your another message.
Hi sir
Sir you forgotten pls share the tricks
@fintaxprime
5 жыл бұрын
Which tricks?
Sorry agar aap ko bura laga ho to
Not understand