Thank you! You saved me from jumping off a bridge! I just wasted 2 hours trying to figure this out! I have subscribed and will visit your channel again next time before I waste so much of my time and sanity! I owe you BIG TIME!!!
I was trying to figure this out for 3 hours, I have use excel before. Acutally since I was 16 yrs old, am 43 now. I tried the Match method, vlookup and also learned xlookup. NOTHING WORKED...until I ran into this video. Thank You!!!!!
Wow!! 😂 it was that easy. I spent a whole day manually looking up data. I had lost hope for vlookup until this video. I just couldn't figure out why I was getting NA. This video saved my pinky. 😂 copy and paste is no joke.
I never comment on video's but I am just over the moon with this one. This has been a headache for me forever and this definetly fixed it/ Thank you for putting this video together. !!!!
I was searching for the same, many UA-camrs were here & there but you have nailed my problem ਮੈਂ ਉਸੇ ਦੀ ਖੋਜ ਕਰ ਰਿਹਾ ਸੀ, ਬਹੁਤ ਸਾਰੇ UA-camrs ਇੱਥੇ ਅਤੇ ਉਥੇ ਸਨ ਪਰ ਤੁਸੀਂ ਮੇਰੀ ਸਮੱਸਿਆ ਨੂੰ ਦੂਰ ਕਰ ਦਿੱਤਾ ਹੈ
Best video in youtube ever done, congratulation you were the only one in the world who could accomplished this, not they can fire all the Indian fromt he MS excel department and give to you all their salary.
Earlier this month, I watched King Charles III get crowned. It should have been this video. 😁 Thank you so so much! Bonus thanks for getting to the point and not making us watch 15 minutes of mostly sales pitches 🙏😃
I don't understand all that you said in my first viewing, but it sure fixes my problem! (maybe will come back and try to understand what it was fixing exactly but..) Thank you!!
who are you bro,, you are awesome , excellent.... last one week i watched some many videos, i did not get the solution, after i seen your videos i applied it, its works well... you are great bro.. god bless you.. sure.. you are the eye opener and fantastic.. Thank you so much bro.. 😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍
Worked like a charm Thanks a ton brother😀 Have been working on it since last 48 hours and watched your video and boom will be able to enjoy the weekend burden free😇 Thanks again
I just copy paste copy paste exel word exel to clear any hidden formatting. Annoying but works fine for me.but for time savings gotta try this.lets see
When receiving data from someone or downloading some from a program, are there any best practices to follow to set you up for best results with vlookup? Example, should I select all sheets I’m about to work with and convert the whole worksheet with the text to column button to give a neutral start to my work? I get any documents from different sources and my columns and references often are a combination of numbers, letters and letter/number combinations and I need my look up to recognize them all, all in the same column. Hopefully you can make sense of that example. I work a lot with UPC’s, skus, product codes, etc.
Hii i wander if there is a way to use vlookup when the column that contains the value is not on the left Let say take your example and say that i want to get the value to match and i have the bbbb value Is there a way to use vlookup and get the value 2
it didnt worked out for me after checking it coz both places numbers are in number format. I used LEN formula to see the length still throwing same NA error
Changing the format won't necessarily change text to number. I recommend running both columns through the "text to columns" function in the data menu. It can reset text to numbers.
You’re genius, absolutely lifesaver 🎉😊
Comments like this make my channel.
Agreed! Thanks so much
i spent 45 min yesterday doing every trick in the book. I take 3 minutes this morning and watch your tutorial. Boom fixed. thank you.
I've felt your pain in the past. Excel LOOKUPs can be difficult to troubleshoot at times. Thanks for the comment.
Thats why i love/hate youtube. Its like really it was that simple and i couldnt figure it out
Thank you! You saved me from jumping off a bridge! I just wasted 2 hours trying to figure this out! I have subscribed and will visit your channel again next time before I waste so much of my time and sanity! I owe you BIG TIME!!!
I was trying to figure this out for 3 hours, I have use excel before. Acutally since I was 16 yrs old, am 43 now. I tried the Match method, vlookup and also learned xlookup. NOTHING WORKED...until I ran into this video. Thank You!!!!!
Excellent! Glad it helped you.
Wow!! 😂 it was that easy. I spent a whole day manually looking up data. I had lost hope for vlookup until this video. I just couldn't figure out why I was getting NA. This video saved my pinky. 😂 copy and paste is no joke.
I never comment on video's but I am just over the moon with this one. This has been a headache for me forever and this definetly fixed it/ Thank you for putting this video together. !!!!
You made my day too. Thanks for the nice comment.
I was searching for the same, many UA-camrs were here & there but you have nailed my problem ਮੈਂ ਉਸੇ ਦੀ ਖੋਜ ਕਰ ਰਿਹਾ ਸੀ, ਬਹੁਤ ਸਾਰੇ UA-camrs ਇੱਥੇ ਅਤੇ ਉਥੇ ਸਨ ਪਰ ਤੁਸੀਂ ਮੇਰੀ ਸਮੱਸਿਆ ਨੂੰ ਦੂਰ ਕਰ ਦਿੱਤਾ ਹੈ
Spent 2-3 hours today trying figure this out. Thanks. Done. Subscribed.
Thank you very much! I knew it was a formatting issue, but couldn't figure out how to fix it!!
Glad I could help!
i was struggling since yesterday 😅 asked everyone of my colleagues but this video solved in just secs. great videos thanks for sharing
Great to hear!
You solved my last 3 year problem in 2 minutes.... hatsoff man.... 🤩✊
I’m glad it worked for you.
i was trying one of my work sheet to do it for one hours, but thanks after watching this video i do in a second. Thank you dear.
You're welcome 😊
It worked! Took me forever to figure it out! Your video helped in under two minutes!
This is life-saving! Thank you so much. I have been searching for days to find a resolution. This worked!
Awesome. I appreciate the comment.
Thank you for posting a really helpful video with a quick answer not forcing us to watch 27 minutes of chatter. You are a legend 😊
Best video in youtube ever done, congratulation you were the only one in the world who could accomplished this, not they can fire all the Indian fromt he MS excel department and give to you all their salary.
This totally worked, I have been trying to fix this error for months.
Earlier this month, I watched King Charles III get crowned. It should have been this video. 😁
Thank you so so much! Bonus thanks for getting to the point and not making us watch 15 minutes of mostly sales pitches 🙏😃
Yes, sometimes we need quick videos that get to the point fast.
I don't understand all that you said in my first viewing, but it sure fixes my problem! (maybe will come back and try to understand what it was fixing exactly but..) Thank you!!
2 Days on this and you fixed it thanks!!😄
Glad I could help!
This issue was irritating me a lot, you fixed this doc
I had to do this to both worksheets but it worked like a charm. Thank you.
You're welcome!
who are you bro,, you are awesome , excellent.... last one week i watched some many videos, i did not get the solution, after i seen your videos i applied it, its works well... you are great bro.. god bless you.. sure.. you are the eye opener and fantastic.. Thank you so much bro.. 😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍
Worked like a charm
Thanks a ton brother😀
Have been working on it since last 48 hours and watched your video and boom
will be able to enjoy the weekend burden free😇
Thanks again
Glad it helped
Amazing. I spend alot time before watching this video but this video resolved my problem.
This example is very great, much more especially if you working with large amount of data.
thanks a lot for this video it actually save me :)😊😊😊
Glad you liked it
It worked !! Thanks for sharing this trick.
Welcome 👍
Very helpful as other VLOOKUP excel video didn't address the error!
Glad it helped!
Thanks so much for helping me do my job at work today. I can go home.
Great!
This worked! Thank you, sir!
You're welcome!
I love you from the bottom of my thankful heart bro.
Have a great life.
Cheers,
Tan
Thanks for the tip, I shall find earlier your tutorial, it could make my day better . 10/10. All the best.
Awesome You solve the problem Thanks buddy Hope will learn More from Great Work
Happy to help
My brother, you are the man. Thank you !
Glad to help
Omfg excel is so anoying sometimes, man you are a life saver for real!
Life saver, thank you so much ❤
You're welcome!
This was exactly what I needed. Thank you so much!
You are so welcome!
I just copy paste copy paste exel word exel to clear any hidden formatting. Annoying but works fine for me.but for time savings gotta try this.lets see
Very helpful! This worked for my vlookup for two separate workbooks 😊
Glad it was helpful!
It worked, subscribed, thank you
Thanks for the sub!
Really succinct and effective. Thanks.
Appreciate the view and comment.
You save my day🎉
thanks for your guide
Any time
This saved me a ton of time. Thanks a lot mate!
You're welcome!
Thank you, been stuck on this for hours ;)
When receiving data from someone or downloading some from a program, are there any best practices to follow to set you up for best results with vlookup?
Example, should I select all sheets I’m about to work with and convert the whole worksheet with the text to column button to give a neutral start to my work?
I get any documents from different sources and my columns and references often are a combination of numbers, letters and letter/number combinations and I need my look up to recognize them all, all in the same column. Hopefully you can make sense of that example. I work a lot with UPC’s, skus, product codes, etc.
An absolute lifesaver, thank you 😭
Nice, thanks!
Thank you thank you ❤❤❤ saved my skin bro
ohhhh finally, thank you and thank god!
Very helpful - thank you!
This is so helpful!! Thanks
Hii i wander if there is a way to use vlookup when the column that contains the value is not on the left
Let say take your example and say that i want to get the value to match and i have the bbbb value
Is there a way to use vlookup and get the value 2
You are a Life saver🤝
Thank you so much. You've solved my problem with this error
Thanks for commenting and glad it helped you.
Thanks for sharing, could you guide me how can I solve this if I’m matching text value eg. Name. Thanks
Text works very well with the Lookup functions but it’s important that the names are exactly the same with no leading or trailing spaces.
This worked, thank you so much!
Glad it helped!
Thank you for this
My pleasure!
How do I get N/A's to sum in a column. Excel is stuck on formulating Vlookup in an array (annoying), and Im stuck not able to sum anything.
YOU ARE A LIFE SAVER! BLESS YOU!
I'm glad that you found it useful. Good luck with Excel and the V & XLOOKUPs
That resolved an annoying issue I had for very long time!
Glad to hear my video helped.
Unfortunately, this didn't work. I don't know what I did wrong. (This has worked for other things but not this time for a reason not known to me.)
You are my saver.. thank you so much for posting this video
Glad to hear that it helped. Thanks for watching and commenting.
Perfect! Thank you!
You Rock, this was exactly my issue!!
Thank you for the valuable info
Glad it was helpful!
BROO YOU'RE MY SAVIOR❤❤❤
thank you!
Thank you so much 🙏🙏
You're most welcome
It worked, thank you
Glad it helped
I have interview last week same scenario I have face , but fail to fix at 😢. But they mention alfabetical instead of numeric numbers
Thank you so much. ❤
You're welcome 😊
Still does not work for me. im pulling data from a filter function.... can't figure it out any way I try
Bro!!! Thank you!!!!! Where can I give you money?
I am having exact issue, but with the names not with the numbers, could you advise? Thanks
Same issue with names. Any advice
Very helpfull tutorial..thanks for sharing, because of that i'm going to hit all the botton on this channel to see more videos to come
Thanks for watching
Love the video
Thank you 😁
You're welcome!
YOU ARE THE BEST
You are the best. You are the best.
You are the beeeeeeeeeeeeeeeest. ❤❤❤❤❤❤❤❤❤❤❤
Thanks
You save my day , thanks ❤
You're welcome 😊
Absolutely helpfull, M gettingmad by my VLOOKUP not work.
What if the lookup value is a list in a data validation?
I'd it's alfa bitical order same tools to be used ?
Worked. ❤
It didn’t work for me. The data in my column contains letters and numbers.
I guess I have to continue with my search.
Excellent! 👍🏻 👍🏻
Thank you sooo much...
Most welcome 😊
Thanks a lot you fix my day
Glad to hear that
You are a savior!!
Good luck with VLOOKUP or xlookup
so helpful, thank you.
You're welcome!
AMAZING! Thank you so much!
You're very welcome!
Its a big help for me thank you so much 👍👍
Glad to hear that
Thanks for the video unfortunately it does not solve my problem
Thank U Sooooo Much
it didnt worked out for me after checking it coz both places numbers are in number format. I used LEN formula to see the length still throwing same NA error
Changing the format won't necessarily change text to number. I recommend running both columns through the "text to columns" function in the data menu. It can reset text to numbers.
How can I do this but with numbers with leading 0’s?
Thank it helps a lot
God bless you
it work perfect