MS Excel - VLookup Approximate Match

[@TutorialsPoint_]

To Get Certification, Click Here: bit.ly/38Jyu3p Use coupon "KZbin12" to get ‘’FLAT 12%’’ OFF at Checkout.

[@tvittal9590]

Thank you for taking the time to us. I sincerely appreciate the time you spent to explain the class and the way you have explained it in the video was excellent. Your video was very helpful for the students, unemployed youth. Once again we thank you heartily for being a part of raising a great nation.

[@RakeshKumar-w9y8n]

Really great learning - simple but effective method to learn

[@stec0123]

khatarnaak ho bhai aap to. also to the viewers, if you are watching his video to gain knowledge for free, please watch the advertisements on his videos. So that he would get paid for his effort of doing social work. May Goddess Saraswati bless you bro.

[@raahymkhan1265]

a brilliant nd concise video explaining exactly what approximate match is

[@mayankxyz4530]

Thank you for making simple video,it give clear understanding of basic Vlookup formulas.

[@Malvikabhardwaj0002]

Really,, I also get shocked how it can be possible,, byetheway this Sonu Nigam's voice also good 😊😊😊

[@PuneCityFarmer]

There was the small error here at 3:26 numbers in the first column should be in ascending order but you mention it as ascending to descending order. Thank you for the session 😊

[@Sidbab1]

Great demonstration and lucidly explained....well done

[@sufiyan0811]

Thank you for giving us a great knowledge I appreciate your work

[@shrey1772]

very good method of teaching. simple and quickly understandable

[@faizancielo]

Good 👍 informative video! Thank you Sir 🤗

[@subhakhowai]

Thank you very much. Beautiful presentation.

[@caanu3771]

Thanks sir for all excel videoes.... really helped me in my interview

[@MakeTheChange9]

Please share the same workbook on which you have been applying the lesson. It will help us in following the exact practice steps. Thanks.

[@RakeshKumar-ov7cs]

Awesome. So well explained. Easy to understand.

[@ShonibarerBarbela]

I never thought Sonu Nigam will teach me excel 😊😊😂😂

[@seeramkris]

Is this sonu nigam?

[@RahulJagtap14]

Excellent explanation !

[@madhvinagaich2226]

Very awesome channel I like whatever doubt comes in my mind sab clear

[@SaiKumar-wt7jc]

Nice explanation sir

[@ShrutiVikas]

Best🎉

[@vasantkumarkantilal2973]

Your tutorial is best of you tube.

[@shalininaidu5451]

Sir, y don't u upload more such videos in your channel

[@ShreyasSinha]

Best explaination

[@sharontoroitich8438]

Great demonstration

[@badboyrk12345]

Sir apne jo pehele se data edit kr rakha hai front me first line me waha per rupees ka symbols kese laye 😢😢😢😢😢😢😢😢😢😢😢😢😢😢😢mere tution teacher bhi pareshan ho gye unse bhi vo data add nahi kiya gya

[@yousufali3902]

amazing job

[@Avulakrishnansp]

Nice presentation

[@chandrikapatra2186]

Thanks for the videos. They are really helpful and easy to understand.

[@Chetansingh-do1bl]

Thank you so much to share your knowledge.

[@ActiveLearningforAll]

Very useful

[@ShortSphere1219]

Awesome video sir👌👌

[@masebastian5656]

Very good training, thanks, Do you have any full video for excel?

[@deekshithtrdeekshi]

can you please provide some related data sheets to practice

[@amanbhargavaofficial]

Thank you😊😊😊😊😊😊❤❤❤

[@masoodahmedshaikh3640]

appx match understood. target achieved.

[@lamotivationcheick2268]

Thank you so much

[@abdulakbershaik7341]

If the sales amount consists of decimal values, how does the approximation work?

[@ramyasivasiva]

Can u tell me the rate for commission amt is calculated

[@subratkundu2877]

Sir how have you put 2 Indian Rupee symbol twice in single cell??

[@preetsehajarneja9283]

Please do provide the link of the excel file as it becomes very difficult to practice without it!

[@thasheelawijesundara9037]

Thank you!💙

[@alonegamer1727]

Agar dusri sheet p list p ho to waha s data validation kaise lagayengr

[@alfredpeabody8115]

Sir please make video on CCE files used in school

[@sohanpal6334]

i have once query why #N/A is coming even after trim all the DATA

[@rakeshkumar-fh5dh]

how can i got your notes sir please help me

[@shamsundar8948]

Thanks sir

[@sarveshchauhan3852]

Sorry Sir, but this approximate match function is not performing properly.

[@littlekidscartoonplanet]

why excel vlookup approximate match second table must be ordered by asc ?

[@srishtishrivastava8818]

Have you got any clarity on this??

[@westfield90]

So well explained

[@k.dstudyknowledge9957]

Thank u

[@uncomparable_unique_creature]

I didn't understand @1:20

[@sajjadsubedar6768]

Good explanation, well teaching.. but Sir please provide free data for practice of Excel. Or suggest any platform where we can find it..

[@Avulakrishnansp]

I have one quary Ie: Don is name of person Don is sale 10 apples, at morning As well as at the same day( afternoon) sales 12 apples and evening sales 23 apples, With in this indeed to display (results) 10 12 23, is it possible

[@ajaybiswas7]

Is it possible, if I write 3 or 4 letters, the whole word will come up from my different Excel data file to fill my current selected cell.

[@SIMRANKAUR-eg7nc]

Not exactly. But u can create a macro button and use wildcards with the lookup value in vlookup formula. Or create a search box in some cell and set ur search value as the lookup value as demanded in the formula.

[@SIMRANKAUR-eg7nc]

The partial match which can he achieved by concatenating wild cards to the lookup value. kzbin.info/www/bejne/a5fWnqxpqtyimZo

[@aravindrameshpiano]

*Thank you for the lesson*

[@gurusam8298]

Very good demo

[@gurusam8298]

🎓 your video much more intellectual

[@arabindablog9146]

nice video sir..

[@shubhangiverma6275]

How to use VLOOKUP when we have same name in column like - clothes,watches,clothes.? I try this but i didn't get the answer? Pls help me sir

[@maneeshrathod3208]

It should be unique name.

[@kundankumarsaraf3563]

Video is wonderful. Only teacher should not be there in this video only file should appear there.

[@sangramsinhpatil7665]

What if I want, for value=1000, ans should be $40 or for value=2500, ans should be $200.? I want the next higher return value for the approximate input value rather than lower return value.

[@chetnakikan3721]

👍👍👍

[@haroonmalik3706]

How to use "₹" sign twice in a single cell. Could anyone 🙏help me.

[@rakeshkumar-fh5dh]

project sheet can provide me please

[@HimanshuSharma-if5ue]

wodderful explanation

[@kapilsharma-zm8bf]

appx ,match in vlookup is not of much use

[@GoBrolympics]

plzz share excel sheet also so we can practice

[@Elearner6162]

21/12/23

[@Desifilmytalkshock]

Hi, If you could share the data with me that would be more helpful for me in case of doing practice. Hope to hear from you soon.

[@shaaniplays9931]

Heard anything 🤣

[@get-gadgetsnow]

match

[@BharathYadav-f6e]

Bharath come

[@prishanishad4660]

Sir please Hindi me btaiye

[@manjunaths6027]

Please share the same workbook on which you have been applying the lesson. It will help us in following the exact practice steps. Thanks.