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.
@ExcelLevelUp
Жыл бұрын
I've felt your pain in the past. Excel LOOKUPs can be difficult to troubleshoot at times. Thanks for the comment.
@ace9resistance
3 ай бұрын
Thats why i love/hate youtube. Its like really it was that simple and i couldnt figure it out
@2dows1
2 ай бұрын
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!!!
@projectmayham4145
10 сағат бұрын
Thank you So much! This is EXACTLY what I needed. I couldn’t figure out which export was formatted incorrectly. This was a quick fix to my problem. 🙏🏼
@jswntsr
8 ай бұрын
I was searching for the same, many KZitemrs were here & there but you have nailed my problem ਮੈਂ ਉਸੇ ਦੀ ਖੋਜ ਕਰ ਰਿਹਾ ਸੀ, ਬਹੁਤ ਸਾਰੇ KZitemrs ਇੱਥੇ ਅਤੇ ਉਥੇ ਸਨ ਪਰ ਤੁਸੀਂ ਮੇਰੀ ਸਮੱਸਿਆ ਨੂੰ ਦੂਰ ਕਰ ਦਿੱਤਾ ਹੈ
@claudmobilemechanic
8 ай бұрын
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!!!!!
@ExcelLevelUp
8 ай бұрын
Excellent! Glad it helped you.
@raymondarce4043
9 ай бұрын
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. !!!!
This is life-saving! Thank you so much. I have been searching for days to find a resolution. This worked!
@ExcelLevelUp
Жыл бұрын
Awesome. I appreciate the comment.
@alexQw33
3 ай бұрын
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 😊
@daniellopez0909talon
8 күн бұрын
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.
@999sen
Жыл бұрын
You solved my last 3 year problem in 2 minutes.... hatsoff man.... 🤩✊
@ExcelLevelUp
Жыл бұрын
I’m glad it worked for you.
@Mony_Travels
10 күн бұрын
It worked! Took me forever to figure it out! Your video helped in under two minutes!
@marypatterson471
8 күн бұрын
Thank you very much! I knew it was a formatting issue, but couldn't figure out how to fix it!!
@ExcelLevelUp
8 күн бұрын
Glad I could help!
@namratanaik4897
10 күн бұрын
i was struggling since yesterday 😅 asked everyone of my colleagues but this video solved in just secs. great videos thanks for sharing
@ExcelLevelUp
8 күн бұрын
Great to hear!
@sajidaliutman5756
Жыл бұрын
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.
@ExcelLevelUp
Жыл бұрын
You're welcome 😊
@traxntrex2994
Жыл бұрын
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 🙏😃
@ExcelLevelUp
Жыл бұрын
Yes, sometimes we need quick videos that get to the point fast.
@RosMyster
2 ай бұрын
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.
@michellechartrand2888
2 ай бұрын
This totally worked, I have been trying to fix this error for months.
@StevenTolliver
3 ай бұрын
2 Days on this and you fixed it thanks!!😄
@ExcelLevelUp
3 ай бұрын
Glad I could help!
@JasonBolte
8 ай бұрын
This was exactly what I needed. Thank you so much!
@ExcelLevelUp
8 ай бұрын
You are so welcome!
@gracenmercy2024
9 ай бұрын
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!!
@MissT813
9 ай бұрын
I had to do this to both worksheets but it worked like a charm. Thank you.
@ExcelLevelUp
8 ай бұрын
You're welcome!
@Vish4891
3 ай бұрын
This issue was irritating me a lot, you fixed this doc
@mayurkakkad007
9 ай бұрын
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
@ExcelLevelUp
8 ай бұрын
Glad it helped
@markhak2911
8 ай бұрын
Thanks for the tip, I shall find earlier your tutorial, it could make my day better . 10/10. All the best.
@ViralAmitSir582
2 ай бұрын
Amazing. I spend alot time before watching this video but this video resolved my problem.
@nivasahamed505
7 ай бұрын
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.. 😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍
@apartment_tourister
11 ай бұрын
I love you from the bottom of my thankful heart bro. Have a great life. Cheers, Tan
@drummersaad
Жыл бұрын
My brother, you are the man. Thank you !
@ExcelLevelUp
Жыл бұрын
Glad to help
@Learn0368
5 ай бұрын
Very helpful as other VLOOKUP excel video didn't address the error!
@ExcelLevelUp
5 ай бұрын
Glad it helped!
@fabioneto3224
Жыл бұрын
Omfg excel is so anoying sometimes, man you are a life saver for real!
@Jeremy-hb6ji
2 ай бұрын
This worked! Thank you, sir!
@ExcelLevelUp
2 ай бұрын
You're welcome!
@avinashshaw-h9b
9 ай бұрын
It worked !! Thanks for sharing this trick.
@ExcelLevelUp
8 ай бұрын
Welcome 👍
@siyabongalinda246
7 ай бұрын
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 :)😊😊😊
@ExcelLevelUp
7 ай бұрын
Glad you liked it
@jan-zg7pf
Жыл бұрын
Really succinct and effective. Thanks.
@ExcelLevelUp
Жыл бұрын
Appreciate the view and comment.
@babololo1437
6 ай бұрын
I am having exact issue, but with the names not with the numbers, could you advise? Thanks
@Mark_Woods
Ай бұрын
Same issue with names. Any advice
@markorakita5445
11 ай бұрын
This saved me a ton of time. Thanks a lot mate!
@ExcelLevelUp
10 ай бұрын
You're welcome!
@euijin78
8 ай бұрын
Thanks so much for helping me do my job at work today. I can go home.
@ExcelLevelUp
8 ай бұрын
Great!
@fabiosanchez8558
3 ай бұрын
This is so helpful!! Thanks
@bjornvandenbroeck8531
11 ай бұрын
Thank you, been stuck on this for hours ;)
@michaelbitner9910
5 ай бұрын
Very helpful - thank you!
@amynguyen4454
4 ай бұрын
Life saver, thank you so much ❤
@ExcelLevelUp
4 ай бұрын
You're welcome!
@kallistahope4711
Жыл бұрын
Very helpful! This worked for my vlookup for two separate workbooks 😊
@ExcelLevelUp
Жыл бұрын
Glad it was helpful!
@FelPacs
2 жыл бұрын
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
@ExcelLevelUp
2 жыл бұрын
Thanks for watching
@lseh
Жыл бұрын
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.
@jeffg5771
6 ай бұрын
It worked, subscribed, thank you
@ExcelLevelUp
6 ай бұрын
Thanks for the sub!
@syedmuhammadowais1285
6 ай бұрын
Awesome You solve the problem Thanks buddy Hope will learn More from Great Work
@ExcelLevelUp
6 ай бұрын
Happy to help
@nz6517
Жыл бұрын
An absolute lifesaver, thank you 😭
@Azari_D
7 ай бұрын
This worked, thank you so much!
@ExcelLevelUp
7 ай бұрын
Glad it helped!
@someonessomething5098
Жыл бұрын
YOU ARE A LIFE SAVER! BLESS YOU!
@ExcelLevelUp
Жыл бұрын
I'm glad that you found it useful. Good luck with Excel and the V & XLOOKUPs
@mountaineerjdm
3 ай бұрын
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.
@TobiasSpliid
7 ай бұрын
Perfect! Thank you!
@MrBombastic6705
3 ай бұрын
You save my day🎉
@user-wc3np4ih3k
Жыл бұрын
You Rock, this was exactly my issue!!
@BigKMST
Жыл бұрын
Thank you for the valuable info
@ExcelLevelUp
Жыл бұрын
Glad it was helpful!
@shoppersdream
5 ай бұрын
Nice, thanks!
@mizmila249
7 ай бұрын
You are a Life saver🤝
@RodrigoSanchez-fp2qz
Жыл бұрын
AMAZING! Thank you so much!
@ExcelLevelUp
Жыл бұрын
You're very welcome!
@user-vi1uw4dy8f
10 ай бұрын
thanks for your guide
@ExcelLevelUp
10 ай бұрын
Any time
@jasimuddin8007
6 ай бұрын
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
@Intellectual_House
5 ай бұрын
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
@julianizdebski5035
3 ай бұрын
Still does not work for me. im pulling data from a filter function.... can't figure it out any way I try
@leongng8997
11 ай бұрын
Thanks for sharing, could you guide me how can I solve this if I’m matching text value eg. Name. Thanks
@ExcelLevelUp
11 ай бұрын
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.
@mibrahimsevgi
7 ай бұрын
ohhhh finally, thank you and thank god!
@AlinAnindya-v8p
2 ай бұрын
BROO YOU'RE MY SAVIOR❤❤❤
@gloryk1797
Жыл бұрын
Thank you so much. You've solved my problem with this error
@ExcelLevelUp
Жыл бұрын
Thanks for commenting and glad it helped you.
@cheerupsouls5673
10 ай бұрын
You save my day , thanks ❤
@ExcelLevelUp
10 ай бұрын
You're welcome 😊
@amferrer95
Ай бұрын
Thank you for this
@ExcelLevelUp
Ай бұрын
My pleasure!
@kesa7669
11 ай бұрын
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.)
@thehowto282
Жыл бұрын
so helpful, thank you.
@ExcelLevelUp
Жыл бұрын
You're welcome!
@mishu_ung
3 ай бұрын
What if the lookup value is a list in a data validation?
@KC28-g7h
Жыл бұрын
You are my saver.. thank you so much for posting this video
@ExcelLevelUp
Жыл бұрын
Glad to hear that it helped. Thanks for watching and commenting.
@ashambo
Жыл бұрын
You are the best. You are the best. You are the beeeeeeeeeeeeeeeest. ❤❤❤❤❤❤❤❤❤❤❤
@ExcelLevelUp
Жыл бұрын
Thanks
@jennywelpilones6001
Жыл бұрын
Its a big help for me thank you so much 👍👍
@ExcelLevelUp
Жыл бұрын
Glad to hear that
@timtim2500
Жыл бұрын
Excellent! 👍🏻 👍🏻
@xiaozhen1169
7 ай бұрын
Thank you so much. ❤
@ExcelLevelUp
7 ай бұрын
You're welcome 😊
@haxreb9062
11 ай бұрын
thank you!
@jdotbeats3727
2 ай бұрын
Thank you thank you ❤❤❤ saved my skin bro
@akankshaaggarwal5880
4 ай бұрын
Thank you so much 🙏🙏
@ExcelLevelUp
4 ай бұрын
You're most welcome
@onye_zadok
Ай бұрын
It didn’t work for me. The data in my column contains letters and numbers. I guess I have to continue with my search.
@bitcoinboy4031
Жыл бұрын
I'd it's alfa bitical order same tools to be used ?
@bitcoinboy4031
Жыл бұрын
I have interview last week same scenario I have face , but fail to fix at 😢. But they mention alfabetical instead of numeric numbers
@reegashrestha136
Жыл бұрын
You are a savior!!
@ExcelLevelUp
Жыл бұрын
Good luck with VLOOKUP or xlookup
@fritzdaz3839
4 ай бұрын
You helped me. Thanks. From year 2024. Hahahah
@ExcelLevelUp
4 ай бұрын
Glad I could help!
@mandraxfilostein
11 ай бұрын
Bro!!! Thank you!!!!! Where can I give you money?
@norma-jeabarsh5266
Жыл бұрын
Thank you 😁
@ExcelLevelUp
Жыл бұрын
You're welcome!
@YasserIsmail
11 ай бұрын
Thanks a lot you fix my day
@ExcelLevelUp
11 ай бұрын
Glad to hear that
@anshuladeshmukh1680
10 ай бұрын
Thank you sooo much...
@ExcelLevelUp
10 ай бұрын
Most welcome 😊
@alfiedj
2 жыл бұрын
This method helped solved my issue. Thank you Sir. Subscribed! = )
@ExcelLevelUp
2 жыл бұрын
Fantastic. Thanks for watching.
@yyosra
11 ай бұрын
YOU ARE THE BEST
@user-hr3vh8kb8s
Жыл бұрын
Thank it helps a lot
@quytruongba6223
5 ай бұрын
Love the video
@noahjones4368
6 ай бұрын
How can I do this but with numbers with leading 0’s?
@jordansabol7251
Жыл бұрын
Wow thank you!
@kumarsasi141
Жыл бұрын
It worked, thank you
@ExcelLevelUp
Жыл бұрын
Glad it helped
@srkganesh2007
Жыл бұрын
Thank you🙏
@newtelent2622
6 ай бұрын
Thank U Sooooo Much
@justinlee4738
10 ай бұрын
That resolved an annoying issue I had for very long time!
Пікірлер: 219