Excel function VLOOKUP returns

[@cloudcloud8481]

This Video saved me ! I have lost two days watching lots of videos to correct my error with no luck. But this comprehensive and smart Video is the only one that helped me correct my error ! Thank you very very very very much !

[@FredericLEGUEN-Excel]

Thank you sooooooo much 😃

[@El_bigC]

After looking at about ten different videos, your video FINALLY showed me my error. I wasn't putting the lookup data in the first column of the table!!! Took me like two hours to figure it out. Thanks a TON!!!

[@FredericLEGUEN-Excel]

😀😀😀😀😀😀 You're welcome 😉

[@ボリヴァ]

It took me 10 hours and 50 minutes to find why I get N/A field and every youtube I check never said that! ! thank you for Example 3!! 👏👏👏👏👏👏👏

[@FredericLEGUEN-Excel]

Thanks for your very nice message 😊

[@ボリヴァ]

@@FredericLEGUEN-Excel question: if I had car manufacturers instead of VIN Numbers, and 7 BMWs and 10 Toyotas and 5 Hondas for example, why do I get only 1 output if i have 7 BMWs using the same formula. it is only catching the 1st BMW row entry in the table.

[@FredericLEGUEN-Excel]

@@ボリヴァ Yes, VLOOKUP returns always the first match. If you want to return more than 1 row, you must use the FILTER function www.excel-exercise.com/how-to-return-many-rows-with-vlookup/

[@lailaabdullahi6921]

I spent an entire day oh my god I’m so drained 😂

[@binoymathew8663]

I saw so many videos regarding the VLOOKUP and the N/A error but none mentioned the most important part that the lookups should be in the 1st column and that's what worked for me. Thank you so much for this video.

[@FredericLEGUEN-Excel]

You're welcome

[@sushantgaikwad1849]

EXACTLY SAME HAPPENED WITH ME. THANK YOU FOR MAKING THIS WONDERFUL IN-DEPTH VIDEO. YOU HAVE EARNED YOURSELF A SUBSCRIBER SIR.

[@deepikarajendran9482]

after watching multiple videos i came here . none of the video helped me to clear the error but your video made sense. perfectly done

[@FredericLEGUEN-Excel]

Thank you 😀

[@pauls7056]

Thank you for posting. Very helpful. The French accent made it even better. Thanks again.

[@FredericLEGUEN-Excel]

Thanks for your message 😊

[@ShahrukhKhan-tr5ib]

First time on YT video I am commenting because you given a lesson which is very important

[@1knoxvox]

Finally found my error after a few times searching... it was the 2nd example. Thanks for this.

[@fatmaaslan6452]

Amazing hints! I looked up about 10 videos and I only found the reason to my error in your video! Thank you for sharing your knowledge. Saved my time!!!

[@FredericLEGUEN-Excel]

Thanks a lot ❤️

[@Poojaverma-fv8je]

Thank you sir, your video solved my vlookup #N/A problem

[@ashish-rs]

Got the solution for my erroring VLOOKUP finally. I was missing the lock as shown at 5:10 Thanks!

[@FredericLEGUEN-Excel]

You're welcome

[@amreenunisaakram8688]

Helped a lot. Thanks for sharing the lock function

[@FredericLEGUEN-Excel]

You're welcome

[@mojdehhamedi3336]

I spent 2 hours to find the error and watched several videos and after watching your video I found the error, thank you so much.

[@FredericLEGUEN-Excel]

Thanks a lot for your message 😃

[@three4one479]

thanks man you saved my knuckles and screen

[@FredericLEGUEN-Excel]

Glad it helps you 😉

[@damilolaadeogun6507]

Thank you so much... Im am really glad I found your video; I've been battling with ex 2 problem for a while and all I had to do was change the column and retry... so much relieve... thank you sooooo much!!!!

[@FredericLEGUEN-Excel]

Which situation solves your problem?

[@damilolaadeogun6507]

@@FredericLEGUEN-Excel example 2

[@adrianamiquilena8790]

aHH! thank you! I had a problem with this function and I didn't know how to solve it until I found your video!

[@MutebiBashir]

Wow.. Thank you for this. Your video is better than Microsoft Excel's guide.

[@codak29]

Great video, solved my problems. I learned a lot about VLOOKUP today.

[@aa-gg9mv]

Very Good illustrations for trying to understand Lookups for a new user picking up this function

[@FredericLEGUEN-Excel]

Thanks 😊

[@Duneek]

Thank you, thank you, thank you! I spent days trying to figure out why my Vlookup wasn't working and it was just having the lookup begin from the very first column.

[@biroti89]

Thank you a million, the 'Lock" function worked wonders 😁😁

[@sonalidesale2962]

Thank you Sir, have been looking!

[@excelgarden301]

Amazing!

[@gabthebasher5538]

Thank you so much, you're a legend mate!

[@FredericLEGUEN-Excel]

Thanks you so much for your message 😊

[@theodule01]

Just Amazing tutorial! You have saved my life! Thank You, Sir!

[@Ravi-xf8dw]

Thank you so much. It was 3rd example I was making a mistake. I have seen so many videos but no one said that.

[@FredericLEGUEN-Excel]

Thanks a lot 😁

[@mahdihanifi5408]

really helpful

[@Thinkingbigwins]

This video helped me also! Thanks a lot

[@govindasamymuralidharan510]

Glad, finally N/A error is no more an irritant for me

[@FredericLEGUEN-Excel]

Thanks for your comment 😃👌

[@rhssuk]

Thank-you, you saved a sleepless night.

[@rajkumarghorai2547]

thank you for this video,

[@FredericLEGUEN-Excel]

You're welcome 😃

[@prashantkiratkar.5747]

Thank you so much sir! Your video is extremely helpful!

[@nbent4607]

Real heroes don't wear capes!!!

[@koolron100]

Thankyou you saved my time

[@FredericLEGUEN-Excel]

You're welcome 😉

[@bubbleblower9993]

Thank you!! Found my error on the 3rd example👍🤩

[@FredericLEGUEN-Excel]

Glad that the video helps you 😉

[@Entertainment_Tv1333]

Thank you, you solved my problem

[@FredericLEGUEN-Excel]

@@Entertainment_Tv1333 you are welcome

[@psum51]

Thank you for this information. I was facing problem same as ex-2.

[@JERosa86]

Amazing! thank you sir!

[@sonu_kr]

saved my life thank you

[@FredericLEGUEN-Excel]

You're welcome 😊

[@LukmanHakim-rf8vv]

Thank your, Sir..

[@FredericLEGUEN-Excel]

You're welcome

[@蓝鱼-s4h]

Saved my day, mate.

[@vipeensadawarte9042]

Thanks Mate !!!

[@redone4605]

thank you very much

[@mmak9553]

Thanks...

[@ayushjain-qs5ep]

lot of thanks. problem solved

[@FredericLEGUEN-Excel]

@@ayushjain-qs5ep you're welcome

[@richyards]

Thanks problem solved thanks

[@amitsharma-fw6cb]

Thanks a lottttt

[@talk2birds128]

I have locked my reference and used false and it still doesn’t work.

[@soumyajit112]

You made my day!!! Thanks a lot :-D

[@alysonsmith6743]

Thank you!

[@brolimba]

Thanks a lot...

[@FredericLEGUEN-Excel]

Your welcome

[@elise7651]

Thanks, this helped me a lot!

[@stephinx]

Thanks

[@Ycremotework]

Thank you :)

[@mbaragamathieu4893]

thanks, I did not know that VLOOKUP cannot look for its left columns values.

[@FredericLEGUEN-Excel]

But now, XLOOKUP is more powerful

[@girliemorales-gera2124]

Do you have any sample so I can practice please

[@QFGEE]

After half an hour I realised it was because one of my values has a space at the end....

[@FredericLEGUEN-Excel]

Such common mistake 😉. It's always a good idea to clean you data with TRIM www.excel-exercise.com/remove-spaces-in-excel-with-trim/

[@mimokeh2518]

Excel function VLOOKUP and choos returns #N/A, why?????????

[@charlesperich2480]

Another thing that screws me up all the time: The vlookup value (not the formula, the VALUE. The text it is looking for) MUST be in the first column. You for some stupid reason, cannot lookup values in any other column.

[@FredericLEGUEN-Excel]

There is 2 ways to return a result on the left column of research. The function XLOOKUP or the combination of INDEX and MATCH

[@mikhailvatsura]

Oh, my gosh. Thanks Lord, I read your comment. Just saved me a life.

[@micheledicesare4081]

Thank you!

[@Keeemooo]

Thank You!