Stop the VLOOKUP

Подписаться 36 тыс.

Просмотров 188 тыс.

50% 1

Quickly discover and solve VLOOKUP errors. Anyone who has worked with Excel in data analytics has run into the #N/A error with VLOOKUP. I provide a quick Excel tutorial to correct 99% of the errors.
In this video, we will be discussing the "N/A" error that often appears when using the vlookup and xlookup functions in Microsoft Excel. The "N/A" error can be a frustrating experience, but don't worry! This video is here to help. We will be walking you through the reasons why this error occurs and providing you with step-by-step instructions on how to resolve it. From understanding the syntax of the vlookup and xlookup functions to correcting common mistakes in the formula, this video will cover everything you need to know to get your spreadsheets back on track. By the end of this video, you will have a solid understanding of how to fix the "N/A" error and be able to confidently use vlookup and xlookup in your future projects. So, grab a cup of coffee and let's get started!
Excel is about working smarter, not harder.
Thumbnail picture credit: Photo by Canva Studio from Pexels
www.pexels.com/@canvastudio?u...

Опубликовано:

13 фев 2022

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 201

@finesky77 Год назад

You’re genius, absolutely lifesaver 🎉😊

@ExcelLevelUp Год назад

Comments like this make my channel.

@zsikulincova 8 месяцев назад

Agreed! Thanks so much

@skilzthatkilz133 Год назад

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 Месяц назад

Thats why i love/hate youtube. Its like really it was that simple and i couldnt figure it out

@2dows1 День назад

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!!!

@AudreyLynn8 Год назад

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.

@jswntsr 6 месяцев назад

I was searching for the same, many RU-vidrs were here & there but you have nailed my problem ਮੈਂ ਉਸੇ ਦੀ ਖੋਜ ਕਰ ਰਿਹਾ ਸੀ, ਬਹੁਤ ਸਾਰੇ RU-vidrs ਇੱਥੇ ਅਤੇ ਉਥੇ ਸਨ ਪਰ ਤੁਸੀਂ ਮੇਰੀ ਸਮੱਸਿਆ ਨੂੰ ਦੂਰ ਕਰ ਦਿੱਤਾ ਹੈ

@frankyfernandes6283 Месяц назад

Spent 2-3 hours today trying figure this out. Thanks. Done. Subscribed.

@raymondarce4043 7 месяцев назад

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. !!!!

@ExcelLevelUp 7 месяцев назад

You made my day too. Thanks for the nice comment.

@999sen Год назад

You solved my last 3 year problem in 2 minutes.... hatsoff man.... 🤩✊

@ExcelLevelUp Год назад

I’m glad it worked for you.

@gracejung5501 7 месяцев назад

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!!

@alexQw33 Месяц назад

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 😊

@mayurkakkad007 6 месяцев назад

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 6 месяцев назад

Glad it helped

@nz6517 Год назад

An absolute lifesaver, thank you 😭

@MissT813 6 месяцев назад

I had to do this to both worksheets but it worked like a charm. Thank you.

@ExcelLevelUp 6 месяцев назад

You're welcome!

@sajidaliutman5756 10 месяцев назад

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 10 месяцев назад

You're welcome 😊

@claudmobilemechanic 6 месяцев назад

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 6 месяцев назад

Excellent! Glad it helped you.

@apartment_tourister 9 месяцев назад

I love you from the bottom of my thankful heart bro. Have a great life. Cheers, Tan

@markhak2911 6 месяцев назад

Thanks for the tip, I shall find earlier your tutorial, it could make my day better . 10/10. All the best.

@RosMyster 8 дней назад

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.

@JasonBolte 6 месяцев назад

This was exactly what I needed. Thank you so much!

@ExcelLevelUp 6 месяцев назад

You are so 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.

@ViralAmitSir582 8 дней назад

Amazing. I spend alot time before watching this video but this video resolved my problem.

@jan-zg7pf Год назад

Really succinct and effective. Thanks.

@ExcelLevelUp Год назад

Appreciate the view and comment.

@drummersaad 10 месяцев назад

My brother, you are the man. Thank you !

@ExcelLevelUp 9 месяцев назад

Glad to help

@kallistahope4711 Год назад

Very helpful! This worked for my vlookup for two separate workbooks 😊

@ExcelLevelUp Год назад

Glad it was helpful!

@user-wc3np4ih3k 10 месяцев назад

You Rock, this was exactly my issue!!

@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

@markorakita5445 9 месяцев назад

This saved me a ton of time. Thanks a lot mate!

@ExcelLevelUp 8 месяцев назад

You're welcome!

@michaelbitner9910 3 месяца назад

Very helpful - thank you!

@fabiosanchez8558 Месяц назад

This is so helpful!! Thanks

@bjornvandenbroeck8531 9 месяцев назад

Thank you, been stuck on this for hours ;)

@StevenTolliver Месяц назад

2 Days on this and you fixed it thanks!!😄

@ExcelLevelUp Месяц назад

Glad I could help!

@siyabongalinda246 5 месяцев назад

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 5 месяцев назад

Glad you liked it

@user-sb7go4rn8w 5 месяцев назад

Perfect! Thank you!

@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.

@RodrigoSanchez-fp2qz Год назад

AMAZING! Thank you so much!

@ExcelLevelUp Год назад

You're very welcome!

@Jeremy-hb6ji 24 дня назад

This worked! Thank you, sir!

@ExcelLevelUp 18 дней назад

You're welcome!

@user-iv1jt9op8r 7 месяцев назад

It worked !! Thanks for sharing this trick.

@ExcelLevelUp 6 месяцев назад

Welcome 👍

@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

@amynguyen4454 2 месяца назад

Life saver, thank you so much ❤

@ExcelLevelUp 2 месяца назад

You're welcome!

@Azari_D 5 месяцев назад

This worked, thank you so much!

@ExcelLevelUp 5 месяцев назад

Glad it helped!

@gloryk1797 Год назад

Thank you so much. You've solved my problem with this error

@ExcelLevelUp Год назад

Thanks for commenting and glad it helped you.

@Vish4891 Месяц назад

This issue was irritating me a lot, you fixed this doc

@alfiedj 2 года назад

This method helped solved my issue. Thank you Sir. Subscribed! = )

@ExcelLevelUp 2 года назад

Fantastic. Thanks for watching.

@nivasahamed505 5 месяцев назад

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.. 😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍😍

@5hunnidfit Год назад

Thank you!🙌🙌👏👏

@jennywelpilones6001 Год назад

Its a big help for me thank you so much 👍👍

@ExcelLevelUp Год назад

Glad to hear that

@user-wc5kl2rg7q 10 месяцев назад

You are my saver.. thank you so much for posting this video

@ExcelLevelUp 10 месяцев назад

Glad to hear that it helped. Thanks for watching and commenting.

@mizmila249 5 месяцев назад

You are a Life saver🤝

@jeffg5771 4 месяца назад

It worked, subscribed, thank you

@ExcelLevelUp 4 месяца назад

Thanks for the sub!

@thehowto282 11 месяцев назад

so helpful, thank you.

@ExcelLevelUp 11 месяцев назад

You're welcome!

@Learn0368 3 месяца назад

Very helpful as other VLOOKUP excel video didn't address the error!

@ExcelLevelUp 3 месяца назад

Glad it helped!

@fabioneto3224 Год назад

Omfg excel is so anoying sometimes, man you are a life saver for real!

@syedmuhammadowais1285 4 месяца назад

Awesome You solve the problem Thanks buddy Hope will learn More from Great Work

@ExcelLevelUp 4 месяца назад

Happy to help

@timtim2500 Год назад

Excellent! 👍🏻‍ 👍🏻‍

@BigKMST Год назад

Thank you for the valuable info

@ExcelLevelUp 11 месяцев назад

Glad it was helpful!

@thepennybarlow 2 года назад

OMG, sooo helpful!!

@ExcelLevelUp 2 года назад

Glad it was helpful!

@cheerupsouls5673 8 месяцев назад

You save my day , thanks ❤

@ExcelLevelUp 8 месяцев назад

You're welcome 😊

@shoppersdream 3 месяца назад

Nice, thanks!

@MrBombastic6705 Месяц назад

You save my day🎉

@unclespoon5495 Год назад

Perfect!

@astralperspectives1184 Год назад

THANK YOU SO MUCH!!!!!!!!!!

@user-hr3vh8kb8s 11 месяцев назад

Thank it helps a lot

@euijin78 6 месяцев назад

Thanks so much for helping me do my job at work today. I can go home.

@ExcelLevelUp 6 месяцев назад

Great!

@reegashrestha136 Год назад

You are a savior!!

@ExcelLevelUp Год назад

Good luck with VLOOKUP or xlookup

@YasserIsmail 9 месяцев назад

Thanks a lot you fix my day

@ExcelLevelUp 9 месяцев назад

Glad to hear that

@jordansabol7251 10 месяцев назад

Wow thank you!

@xiaozhen1169 5 месяцев назад

Thank you so much. ❤

@ExcelLevelUp 4 месяца назад

You're welcome 😊

@srkganesh2007 Год назад

Thank you🙏

@akankshaaggarwal5880 2 месяца назад

Thank you so much 🙏🙏

@ExcelLevelUp 2 месяца назад

You're most welcome

@haxreb9062 9 месяцев назад

thank you!

@user-vi1uw4dy8f 8 месяцев назад

thanks for your guide

@ExcelLevelUp 8 месяцев назад

Any time

@jdotbeats3727 9 дней назад

Thank you thank you ❤❤❤ saved my skin bro

@shinetzion 5 месяцев назад

Thank you so much ❣❣❣❣

@ExcelLevelUp 5 месяцев назад

You are so welcome

@mohamedelhadi5901 2 года назад

thank you so much bro

@ExcelLevelUp 2 года назад

You're welcome! Good luck with Excel and VLOOKUP.

@mibrahimsevgi 4 месяца назад

ohhhh finally, thank you and thank god!

@anshuladeshmukh1680 8 месяцев назад

Thank you sooo much...

@ExcelLevelUp 8 месяцев назад

Most welcome 😊

@uwadiegwuemmanuel8809 2 года назад

Thanks

@dummiesturtle1924 Год назад

THANK YOUUU SO MUCHH

@shaikazhar3599 2 месяца назад

Worked. ❤

@nkl6411 Год назад

Lifesaver!🙏

@quytruongba6223 3 месяца назад

Love the video

@Intellectual_House 3 месяца назад

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

@newtelent2622 4 месяца назад

Thank U Sooooo Much

@kumarsasi141 11 месяцев назад

It worked, thank you

@ExcelLevelUp 11 месяцев назад

Glad it helped

@niranjanpremkumar647 Год назад

Thank you

@norma-jeabarsh5266 10 месяцев назад

Thank you 😁

@ExcelLevelUp 10 месяцев назад

You're welcome!

@leongng8997 9 месяцев назад

Thanks for sharing, could you guide me how can I solve this if I’m matching text value eg. Name. Thanks

@ExcelLevelUp 9 месяцев назад

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.

@yyosra 9 месяцев назад

YOU ARE THE BEST

@dataavenger Год назад

Oh man you solve my lots big prob.🎉❤

@ExcelLevelUp Год назад

Happy to help

@bitcoinboy4031 Год назад

I have interview last week same scenario I have face , but fail to fix at 😢. But they mention alfabetical instead of numeric numbers

@bitcoinboy4031 Год назад

I'd it's alfa bitical order same tools to be used ?

@babololo1437 4 месяца назад

I am having exact issue, but with the names not with the numbers, could you advise? Thanks

@justinlee4738 8 месяцев назад

That resolved an annoying issue I had for very long time!

@ExcelLevelUp 8 месяцев назад

Glad to hear my video helped.

@ashambo 10 месяцев назад

You are the best. You are the best. You are the beeeeeeeeeeeeeeeest. ❤❤❤❤❤❤❤❤❤❤❤

@ExcelLevelUp 10 месяцев назад

Thanks

@raghurags3043 Год назад

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

@ExcelLevelUp Год назад

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.