No video :(

Stop the VLOOKUP

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

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

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

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@finesky77 Год назад

You’re genius, absolutely lifesaver 🎉😊

@ExcelLevelUp Год назад

Comments like this make my channel.

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

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

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

@2dows1 28 дней назад

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

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

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

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

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

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 😊

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

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

Excellent! Glad it helped you.

@999sen Год назад

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

@ExcelLevelUp Год назад

I’m glad it worked for you.

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

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

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

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

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

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

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

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

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

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

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

You're welcome!

@nz6517 Год назад

An absolute lifesaver, thank you 😭

@michellechartrand2888 29 дней назад

This totally worked, I have been trying to fix this error for months.

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

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

You're welcome 😊

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

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.

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

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

Glad it helped

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

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

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

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

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

Very helpful - thank you!

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

Really succinct and effective. Thanks.

@ExcelLevelUp Год назад

Appreciate the view and comment.

@kallistahope4711 Год назад

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

@ExcelLevelUp Год назад

Glad it was helpful!

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

Thank you, been stuck on this for hours ;)

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

You Rock, this was exactly my issue!!

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

My brother, you are the man. Thank you !

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

Glad to help

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

This is so helpful!! Thanks

@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

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

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

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

You're welcome!

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

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

Perfect! Thank you!

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

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

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

Glad I could help!

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

It worked !! Thanks for sharing this trick.

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

Welcome 👍

@bitcoinboy4031 Год назад

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

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

Life saver, thank you so much ❤

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

You're welcome!

@Jeremy-hb6ji Месяц назад

This worked! Thank you, sir!

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

You're welcome!

@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

@miniworkaholic 7 дней назад

Thank you for this

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

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

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

Nice, thanks!

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

AMAZING! Thank you so much!

@ExcelLevelUp Год назад

You're very welcome!

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

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

Glad you liked it

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

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

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

Glad it helped!

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

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

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

Happy to help

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

It worked, subscribed, thank you

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

Thanks for the sub!

@timtim2500 Год назад

Excellent! 👍🏻‍ 👍🏻‍

@5hunnidfit Год назад

Thank you!🙌🙌👏👏

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

You save my day🎉

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

This worked, thank you so much!

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

Glad it helped!

@fabioneto3224 Год назад

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

@gloryk1797 Год назад

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

@ExcelLevelUp Год назад

Thanks for commenting and glad it helped you.

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

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

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

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

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

You are a Life saver🤝

@jennywelpilones6001 Год назад

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

@ExcelLevelUp Год назад

Glad to hear that

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

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

@BigKMST Год назад

Thank you for the valuable info

@ExcelLevelUp Год назад

Glad it was helpful!

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

ohhhh finally, thank you and thank god!

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

thank you!

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

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

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

Fantastic. Thanks for watching.

@thehowto282 Год назад

so helpful, thank you.

@ExcelLevelUp Год назад

You're welcome!

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

Thank it helps a lot

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

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

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

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.

@bitcoinboy4031 Год назад

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

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

thanks for your guide

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

Any time

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

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

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

Great!

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

Thank you so much. ❤

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

You're welcome 😊

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

What if the lookup value is a list in a data validation?

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

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.

@astralperspectives1184 Год назад

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

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

Wow thank you!

@unclespoon5495 Год назад

Perfect!

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

Thanks

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

OMG, sooo helpful!!

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

Glad it was helpful!

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

Thank you thank you ❤❤❤ saved my skin bro

@srkganesh2007 Год назад

Thank you🙏

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

You save my day , thanks ❤

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

You're welcome 😊

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

Thank you so much ❣❣❣❣

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

You are so welcome

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

Thank you sooo much...

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

Most welcome 😊

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

Thank you so much 🙏🙏

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

You're most welcome

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

Thank U Sooooo Much

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

Love the video

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

Worked. ❤

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

thank you so much bro

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

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

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

How can I do this but with numbers with leading 0’s?

@niranjanpremkumar647 Год назад

Thank you

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

YOU ARE THE BEST

@reegashrestha136 Год назад

You are a savior!!

@ExcelLevelUp Год назад

Good luck with VLOOKUP or xlookup

@dummiesturtle1924 Год назад

THANK YOUUU SO MUCHH

@nkl6411 Год назад

Lifesaver!🙏

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

Thank you 😁

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

You're welcome!

@kumarsasi141 Год назад

It worked, thank you

@ExcelLevelUp Год назад

Glad it helped

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

Still does not work for me. im pulling data from a filter function.... can't figure it out any way I try

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

Thanks a lot you fix my day

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

Glad to hear that

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

it work perfect

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

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

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

Thanks

@dataavenger Год назад

Oh man you solve my lots big prob.🎉❤

@ExcelLevelUp Год назад

Happy to help

@kwambydee187 21 день назад

Thank you🎉🎉🎉❤❤❤😂😂😂