Stop the VLOOKUP

Рет қаралды 191,560

2 жыл бұрын

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

Пікірлер: 203

@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 10 күн бұрын

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 KZfaqrs were here & there but you have nailed my problem ਮੈਂ ਉਸੇ ਦੀ ਖੋਜ ਕਰ ਰਿਹਾ ਸੀ, ਬਹੁਤ ਸਾਰੇ KZfaqrs ਇੱਥੇ ਅਤੇ ਉਥੇ ਸਨ ਪਰ ਤੁਸੀਂ ਮੇਰੀ ਸਮੱਸਿਆ ਨੂੰ ਦੂਰ ਕਰ ਦਿੱਤਾ ਹੈ

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

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

@frankyfernandes6283 Ай бұрын

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

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

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

@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

@MissT813 7 ай бұрын

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

@ExcelLevelUp 7 ай бұрын

You're welcome!

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

@apartment_tourister 9 ай бұрын

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

@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

@JasonBolte 6 ай бұрын

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

@ExcelLevelUp 6 ай бұрын

You are so welcome!

@jan-zg7pf Жыл бұрын

Really succinct and effective. Thanks.

@ExcelLevelUp Жыл бұрын

Appreciate the view and comment.

@nz6517 Жыл бұрын

An absolute lifesaver, thank you 😭

@markorakita5445 9 ай бұрын

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

@ExcelLevelUp 8 ай бұрын

You're welcome!

@bitcoinboy4031 Жыл бұрын

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

@kallistahope4711 Жыл бұрын

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

@ExcelLevelUp Жыл бұрын

Glad it was helpful!

@bitcoinboy4031 Жыл бұрын

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

@ViralAmitSir582 17 күн бұрын

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

@drummersaad 10 ай бұрын

My brother, you are the man. Thank you !

@ExcelLevelUp 10 ай бұрын

Glad to help

@bjornvandenbroeck8531 9 ай бұрын

Thank you, been stuck on this for hours ;)

@user-wc3np4ih3k 10 ай бұрын

You Rock, this was exactly my issue!!

@Azari_D 6 ай бұрын

This worked, thank you so much!

@ExcelLevelUp 6 ай бұрын

Glad it helped!

@michaelbitner9910 4 ай бұрын

Very helpful - thank you!

@Jeremy-hb6ji Ай бұрын

This worked! Thank you, sir!

@ExcelLevelUp 27 күн бұрын

You're welcome!

@fabiosanchez8558 2 ай бұрын

This is so helpful!! Thanks

@michellechartrand2888 11 күн бұрын

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

@babololo1437 4 ай бұрын

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

@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

@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

@RosMyster 17 күн бұрын

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.

@user-iv1jt9op8r 7 ай бұрын

It worked !! Thanks for sharing this trick.

@ExcelLevelUp 7 ай бұрын

Welcome 👍

@amynguyen4454 3 ай бұрын

Life saver, thank you so much ❤

@ExcelLevelUp 3 ай бұрын

You're welcome!

@StevenTolliver Ай бұрын

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

@ExcelLevelUp Ай бұрын

Glad I could help!

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

@RodrigoSanchez-fp2qz Жыл бұрын

AMAZING! Thank you so much!

@ExcelLevelUp Жыл бұрын

You're very welcome!

@user-sb7go4rn8w 5 ай бұрын

Perfect! Thank you!

@jeffg5771 5 ай бұрын

It worked, subscribed, thank you

@ExcelLevelUp 4 ай бұрын

Thanks for the sub!

@mizmila249 5 ай бұрын

You are a Life saver🤝

@Vish4891 Ай бұрын

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

@Learn0368 3 ай бұрын

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

@ExcelLevelUp 3 ай бұрын

Glad it helped!

@alfiedj 2 жыл бұрын

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

@ExcelLevelUp 2 жыл бұрын

Fantastic. Thanks for watching.

@shoppersdream 3 ай бұрын

Nice, thanks!

@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

@mountaineerjdm Ай бұрын

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.

@jennywelpilones6001 Жыл бұрын

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

@ExcelLevelUp Жыл бұрын

Glad to hear that

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

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

@fabioneto3224 Жыл бұрын

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

@thehowto282 11 ай бұрын

so helpful, thank you.

@ExcelLevelUp 11 ай бұрын

You're welcome!

@syedmuhammadowais1285 4 ай бұрын

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

@ExcelLevelUp 4 ай бұрын

Happy to help

@BigKMST Жыл бұрын

Thank you for the valuable info

@ExcelLevelUp Жыл бұрын

Glad it was helpful!

@gloryk1797 Жыл бұрын

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

@ExcelLevelUp Жыл бұрын

Thanks for commenting and glad it helped you.

@MrBombastic6705 Ай бұрын

You save my day🎉

@cheerupsouls5673 8 ай бұрын

You save my day , thanks ❤

@ExcelLevelUp 8 ай бұрын

You're welcome 😊

@5hunnidfit Жыл бұрын

Thank you!🙌🙌👏👏

@thepennybarlow 2 жыл бұрын

OMG, sooo helpful!!

@ExcelLevelUp 2 жыл бұрын

Glad it was helpful!

@xiaozhen1169 5 ай бұрын

Thank you so much. ❤

@ExcelLevelUp 5 ай бұрын

You're welcome 😊

@timtim2500 Жыл бұрын

Excellent! 👍🏻‍ 👍🏻‍

@mishu_ung 2 ай бұрын

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

@julianizdebski5035 Ай бұрын

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

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

@YasserIsmail 9 ай бұрын

Thanks a lot you fix my day

@ExcelLevelUp 9 ай бұрын

Glad to hear that

@mibrahimsevgi 5 ай бұрын

ohhhh finally, thank you and thank god!

@haxreb9062 9 ай бұрын

thank you!

@shinetzion 6 ай бұрын

Thank you so much ❣❣❣❣

@ExcelLevelUp 6 ай бұрын

You are so welcome

@user-hr3vh8kb8s 11 ай бұрын

Thank it helps a lot

@user-vi1uw4dy8f 8 ай бұрын

thanks for your guide

@ExcelLevelUp 8 ай бұрын

Any time

@quytruongba6223 3 ай бұрын

Love the video

@akankshaaggarwal5880 2 ай бұрын

Thank you so much 🙏🙏

@ExcelLevelUp 2 ай бұрын

You're most welcome

@reegashrestha136 Жыл бұрын

You are a savior!!

@ExcelLevelUp Жыл бұрын

Good luck with VLOOKUP or xlookup

@jordansabol7251 11 ай бұрын

Wow thank you!

@noahjones4368 4 ай бұрын

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

@anshuladeshmukh1680 8 ай бұрын

Thank you sooo much...

@ExcelLevelUp 8 ай бұрын

Most welcome 😊

@euijin78 6 ай бұрын

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

@ExcelLevelUp 6 ай бұрын

Great!

@kumarsasi141 11 ай бұрын

It worked, thank you

@ExcelLevelUp 11 ай бұрын

Glad it helped

@astralperspectives1184 Жыл бұрын

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

@mohamedelhadi5901 2 жыл бұрын

thank you so much bro

@ExcelLevelUp 2 жыл бұрын

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

@newtelent2622 4 ай бұрын

Thank U Sooooo Much

@norma-jeabarsh5266 11 ай бұрын

Thank you 😁

@ExcelLevelUp 11 ай бұрын

You're welcome!

@yyosra 9 ай бұрын

YOU ARE THE BEST

@shaikazhar3599 2 ай бұрын

Worked. ❤

@srkganesh2007 Жыл бұрын

Thank you🙏

@jdotbeats3727 18 күн бұрын

Thank you thank you ❤❤❤ saved my skin bro

@unclespoon5495 Жыл бұрын

Perfect!

@kesa7669 9 ай бұрын

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

@dummiesturtle1924 Жыл бұрын

THANK YOUUU SO MUCHH

@nkl6411 Жыл бұрын

Lifesaver!🙏

@niranjanpremkumar647 Жыл бұрын

Thank you

@uwadiegwuemmanuel8809 2 жыл бұрын

Thanks

@jasimuddin8007 4 ай бұрын

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