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.
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 😊
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.
![How To Apply VLOOKUP and XLOOKUP Formula on Large Data in Excel [Hindi] #excel](/img/n.gif)
To Get Certification, Click Here: bit.ly/38Jyu3p
Use coupon "TH-cam12" 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.
Really great learning - simple but effective method to learn
Thank you for making simple video,it give clear understanding of basic Vlookup formulas.
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 😊
Thank you for giving us a great knowledge I appreciate your work
Great demonstration and lucidly explained....well done
very good method of teaching. simple and quickly understandable
Thanks sir for all excel videoes.... really helped me in my interview
Please share the same workbook on which you have been applying the lesson. It will help us in following the exact practice steps. Thanks.
Awesome. So well explained. Easy to understand.
Good 👍 informative video! Thank you Sir 🤗
Thank you very much. Beautiful presentation.
Your tutorial is best of you tube.
Very awesome channel I like whatever doubt comes in my mind sab clear
Best🎉
Nice Explaination
Excellent explanation !
Best explaination
I never thought Sonu Nigam will teach me excel 😊😊😂😂
Is this sonu nigam?
@@seeramkrisyes
Thanks for the videos. They are really helpful and easy to understand.
Nice explanation sir
Thank you😊😊😊😊😊😊❤❤❤
Very useful
Thank you so much to share your knowledge.
Nice presentation
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
Great demonstration
Sir, y don't u upload more such videos in your channel
Awesome video sir👌👌
Very good training, thanks, Do you have any full video for excel?
amazing job
can you please provide some
related data sheets to practice
Thank you!💙
Sorry Sir, but this approximate match function is not performing properly.
Thank you so much
Agar dusri sheet p list p ho to waha s data validation kaise lagayengr
Sir how have you put 2 Indian Rupee symbol twice in single cell??
Please do provide the link of the excel file as it becomes very difficult to practice without it!
Can u tell me the rate for commission amt is calculated
appx match understood. target achieved.
i have once query why #N/A is coming even after trim all the DATA
how can i got your notes sir please help me
If the sales amount consists of decimal values, how does the approximation work?
Thank u
Thanks sir
👍👍👍
why excel vlookup approximate match second table must be ordered by asc ?
Have you got any clarity on this??
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.
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
Sir please make video on CCE files used in school
I didn't understand @1:20
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.
th-cam.com/video/5fsmy3uwoc8/w-d-xo.html
Good explanation, well teaching.. but Sir please provide free data for practice of Excel. Or suggest any platform where we can find it..
🎓 your video much more intellectual
So well explained
*Thank you for the lesson*
nice video sir..
Video is wonderful. Only teacher should not be there in this video only file should appear there.
Very good demo
project sheet can provide me please
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 to use "₹" sign twice in a single cell. Could anyone 🙏help me.
wodderful explanation
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 🤣
21/12/23
appx ,match in vlookup is not of much use
plzz share excel sheet also so we can practice
match
Sir please Hindi me btaiye
Bharath come
Please share the same workbook on which you have been applying the lesson. It will help us in following the exact practice steps. Thanks.