MS Excel - VLookup Approximate Match 

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

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.

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.

I couldn't hold back from commenting for such a crisp informative video, THANK YOU! I wish I had checked these videos long back! Thank you once again "Tutorials Point"!

Really great learning - simple but effective method to learn

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

Great demonstration and lucidly explained....well done

a brilliant nd concise video explaining exactly what approximate match is

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

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 😊

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

Thank you very much. Beautiful presentation.

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

very good method of teaching. simple and quickly understandable

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

Good 👍 informative video! Thank you Sir 🤗

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

Awesome. So well explained. Easy to understand.

Best explaination

Excellent explanation !

Very useful

Your tutorial is best of you tube.

Nice explanation sir

Thank you so much to share your knowledge.

Great demonstration

amazing job

Nice presentation

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

Thank you so much

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

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

Awesome video sir👌👌

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

Thanks sir

Thank you😊😊😊😊😊😊❤❤❤

Thank you!💙

appx match understood. target achieved.

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

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

Thank u

can you please provide some related data sheets to practice

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

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

So well explained

*Thank you for the lesson*

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

nice video sir..

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

Very good demo

Sir please make video on CCE files used in school

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

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

Can u tell me the rate for commission amt is calculated

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

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.

🎓 your video much more intellectual

how can i got your notes sir please help me

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

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.

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

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

👍👍👍

wodderful explanation

project sheet can provide me please

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

appx ,match in vlookup is not of much use

plzz share excel sheet also so we can practice

I didn't understand @1:20

21/12/23

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.

Sir please Hindi me btaiye

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