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.
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"!
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.
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
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
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.
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.
To Get Certification, Click Here: bit.ly/38Jyu3p
Use coupon "CZcams12" 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.
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"!
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.
Really great learning - simple but effective method to learn
Thank you for making simple video,it give clear understanding of basic Vlookup formulas.
Really,, I also get shocked how it can be possible,, byetheway this Sonu Nigam's voice also good 😊😊😊
a brilliant nd concise video explaining exactly what approximate match is
I never thought Sonu Nigam will teach me excel 😊😊😂😂
Great demonstration and lucidly explained....well done
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
Thanks sir for all excel videoes.... really helped me in my interview
Thank you very much. Beautiful presentation.
Awesome. So well explained. Easy to understand.
Very useful
Good 👍 informative video! Thank you Sir 🤗
Excellent explanation !
Your tutorial is best of you tube.
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
Best explaination
Thank you so much to share your knowledge.
Nice explanation sir
Thanks for the videos. They are really helpful and easy to understand.
Great demonstration
Please do provide the link of the excel file as it becomes very difficult to practice without it!
Very awesome channel I like whatever doubt comes in my mind sab clear
Nice presentation
amazing job
Very good training, thanks, Do you have any full video for excel?
Sorry Sir, but this approximate match function is not performing properly.
can you please provide some
related data sheets to practice
appx match understood. target achieved.
Thank you so much
If the sales amount consists of decimal values, how does the approximation work?
Agar dusri sheet p list p ho to waha s data validation kaise lagayengr
Awesome video sir👌👌
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
Thank u
Thank you!💙
Thank you😊😊😊😊😊😊❤❤❤
Good explanation, well teaching.. but Sir please provide free data for practice of Excel. Or suggest any platform where we can find it..
Sir, y don't u upload more such videos in your channel
Thanks sir
Sir how have you put 2 Indian Rupee symbol twice in single cell??
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
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.
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.
The partial match which can he achieved by concatenating wild cards to the lookup value.
czcams.com/video/5fsmy3uwoc8/video.html
Video is wonderful. Only teacher should not be there in this video only file should appear there.
So well explained
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.
how can i got your notes sir please help me
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
It should be unique name.
Sir please make video on CCE files used in school
*Thank you for the lesson*
why excel vlookup approximate match second table must be ordered by asc ?
Have you got any clarity on this??
Very good demo
nice video sir..
👍👍👍
How to use "₹" sign twice in a single cell. Could anyone 🙏help me.
🎓 your video much more intellectual
I didn't understand @1:20
project sheet can provide me please
wodderful explanation
appx ,match in vlookup is not of much use
21/12/23
plzz share excel sheet also so we can practice
Sir please Hindi me btaiye
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.
Heard anything 🤣
Please share the same workbook on which you have been applying the lesson. It will help us in following the exact practice steps. Thanks.