Excel function VLOOKUP returns

[@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 😉

[@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 😃

[@ボリヴァ]

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 😊

[@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 ❤️

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

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

[@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 😃

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

[@MutebiBashir]

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

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

[@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 😁😁

[@codak29]

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

[@amreenunisaakram8688]

Helped a lot. Thanks for sharing the lock function

[@FredericLEGUEN-Excel]

You're welcome

[@aa-gg9mv]

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

[@FredericLEGUEN-Excel]

Thanks 😊

[@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 😁

[@theodule01]

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

[@Poojaverma-fv8je]

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

[@three4one479]

thanks man you saved my knuckles and screen

[@FredericLEGUEN-Excel]

Glad it helps you 😉

[@gabthebasher5538]

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

[@FredericLEGUEN-Excel]

Thanks you so much for your message 😊

[@sonalidesale2962]

Thank you Sir, have been looking!

[@prashantkiratkar.5747]

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

[@Thinkingbigwins]

This video helped me also! Thanks a lot

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

[@rajkumarghorai2547]

thank you for this video,

[@FredericLEGUEN-Excel]

You're welcome 😃

[@psum51]

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

[@excelgarden301]

Amazing!

[@koolron100]

Thankyou you saved my time

[@FredericLEGUEN-Excel]

You're welcome 😉

[@talk2birds128]

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

[@JERosa86]

Amazing! thank you sir!

[@govindasamymuralidharan510]

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

[@FredericLEGUEN-Excel]

Thanks for your comment 😃👌

[@mahdihanifi5408]

really helpful

[@rhssuk]

Thank-you, you saved a sleepless night.

[@sonu_kr]

saved my life thank you

[@FredericLEGUEN-Excel]

You're welcome 😊

[@nbent4607]

Real heroes don't wear capes!!!

[@蓝鱼-s4h]

Saved my day, mate.

[@soumyajit112]

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

[@LukmanHakim-rf8vv]

Thank your, Sir..

[@FredericLEGUEN-Excel]

You're welcome

[@ayushjain-qs5ep]

lot of thanks. problem solved

[@FredericLEGUEN-Excel]

@@ayushjain-qs5ep you're welcome

[@vipeensadawarte9042]

Thanks Mate !!!

[@redone4605]

thank you very much

[@richyards]

Thanks problem solved thanks

[@mbaragamathieu4893]

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

[@FredericLEGUEN-Excel]

But now, XLOOKUP is more powerful

[@elise7651]

Thanks, this helped me a lot!

[@alysonsmith6743]

Thank you!

[@mmak9553]

Thanks...

[@brolimba]

Thanks a lot...

[@FredericLEGUEN-Excel]

Your welcome

[@amitsharma-fw6cb]

Thanks a lottttt

[@Ycremotework]

Thank you :)

[@stephinx]

Thanks

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