Was going through a course, watched a section like 5 times today, didn't understand. Watched this video once and I understand vlookup and why in some cases index match is superior. Brilliantly explained man. Nothing fancy, so simple yet perfect. Thank you.
you got a new subscriber . because not only you answered Vlookup but also the question that how do we look for values which are not in the first column , which raised in my mind while watching the video . Thanks
Also check out the comprehensive guide to all sorts of lookups, index+match, multi-condition lookups and multiple return values etc. here: chandoo.org/wp/comprehensive-guide-excel-vlookup/
Learning to use the VLOOKUP from this video really helped me by saving so much time in my job when I was still employed. I will continue to learn from your videos and tips and tricks to become good in excel. I hope to use to to get my next job. Thank you :)
This is a great video. I need help in a formula to return a result at the second from last entry in a table. vlook finds the last entry soI need to use offset??
Hi, I have more data in Excel. For Example 200 Rahul & 2000 Virat Name available in Excel,but Dhoni name missed due to typo Error. How to find Missing Name in the Excel ? If any Macro available?
Was it a test team selection list? :P Jokes aside, you can compare two lists to see matches, omissions and more easily. Check this out: chandoo.org/wp/compare-2-lists-in-excel/
What if more than one salesperson both had net sales of 2133? The index+match formula will only give us the first salesperson it finds with that exact match. What can we do about this problem?
I love excel because you made it so interesting to learn. Thanks a lot.
Was going through a course, watched a section like 5 times today, didn't understand.
Watched this video once and I understand vlookup and why in some cases index match is superior. Brilliantly explained man. Nothing fancy, so simple yet perfect. Thank you.
Great to hear! Happy learning :)
you got a new subscriber . because not only you answered Vlookup but also the question that how do we look for values which are not in the first column , which raised in my mind while watching the video . Thanks
Thank you and Welcome Shahan :)
If two names are same how can we use Vlookup?
Also check out the comprehensive guide to all sorts of lookups, index+match, multi-condition lookups and multiple return values etc. here: chandoo.org/wp/comprehensive-guide-excel-vlookup/
Learning to use the VLOOKUP from this video really helped me by saving so much time in my job when I was still employed. I will continue to learn from your videos and tips and tricks to become good in excel. I hope to use to to get my next job.
Thank you :)
Mr Chandoo, I must say your have a great power of teaching. Thank you for this video.
You are very welcome
What if there are same salesperson two times.. What shall be the output?
Answering after checking. It throws the value of first salesperson.
Why is it that if I use name for the lookup value it gives me N/A but if I use cell number I get an outcome.Someone assist.
Sir How we can combine 2 sheets with Same data by vlookup? please suggest
U r excel learnings are too good
Thank you MJ.
How do I get the value for Who made more sales - Jamie or Jackie?
This is a great video. I need help in a formula to return a result at the second from last entry in a table. vlook finds the last entry soI need to use offset??
Hi Chandoo, this vlookup function is not working in my excel2016...is anyone also facing the same error..
What error are you getting?
Hi,
I have more data in Excel. For Example 200 Rahul & 2000 Virat Name available in Excel,but Dhoni name missed due to typo Error.
How to find Missing Name in the Excel ? If any Macro available?
Was it a test team selection list? :P
Jokes aside, you can compare two lists to see matches, omissions and more easily. Check this out:
chandoo.org/wp/compare-2-lists-in-excel/
You are good teacher, Chandoo. Thank you.
This was more than helpful👏
If error-4:24
Index + Match- 7:29, 9:38
What if more than one salesperson both had net sales of 2133? The index+match formula will only give us the first salesperson it finds with that exact match. What can we do about this problem?
You can use other techniques to get all matching values. See this page - chandoo.org/wp/vlookup-second-value/
Hi,
I have more data in Excel. For Example 200 Rahul & 2000 Virat Name available in Excel.
How to find How many Virat in my Excel?
You can use COUNTIFS to find the answer. =COUNTIFS(your names range, "Virat") should work.
Thanks Bro...Its working wellll....
Chandoo ur my life saver ….. ur my daily bread of knowledge
😀 Thank you Lakbay...
Excelente video!
I am fan of your sir
thankyou sir
Please attach the excel files here
Most videos have Excel files attached. Just refer to video description and follow the links.
Thanks !
I am your fan!!
You are Welcome Rohit...
Thank you