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 😉

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

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

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

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

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

[@aa-gg9mv]

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

[@FredericLEGUEN-Excel]

Thanks 😊

[@pauls7056]

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

[@FredericLEGUEN-Excel]

Thanks for your message 😊

[@amreenunisaakram8688]

Helped a lot. Thanks for sharing the lock function

[@FredericLEGUEN-Excel]

You're welcome

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

[@MutebiBashir]

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

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

[@mahdihanifi5408]

really helpful

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

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

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

[@codak29]

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

[@excelgarden301]

Amazing!

[@sonalidesale2962]

Thank you Sir, have been looking!

[@talk2birds128]

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

[@theodule01]

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

[@prashantkiratkar.5747]

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

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

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

[@biroti89]

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

[@Thinkingbigwins]

This video helped me also! Thanks a lot

[@prateeksuman51]

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

[@nbent4607]

Real heroes don't wear capes!!!

[@rhssuk]

Thank-you, you saved a sleepless night.

[@JERosa86]

Amazing! thank you sir!

[@gabthebasher5538]

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

[@FredericLEGUEN-Excel]

Thanks you so much for your message 😊

[@govindasamymuralidharan510]

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

[@FredericLEGUEN-Excel]

Thanks for your comment 😃👌

[@rajkumarghorai2547]

thank you for this video,

[@FredericLEGUEN-Excel]

You're welcome 😃

[@richyards]

Thanks problem solved thanks

[@Entertainment_Tv1333]

Thank you, you solved my problem

[@FredericLEGUEN-Excel]

@@Entertainment_Tv1333 you are welcome

[@koolron100]

Thankyou you saved my time

[@FredericLEGUEN-Excel]

You're welcome 😉

[@mmak9553]

Thanks...

[@bubbleblower9993]

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

[@FredericLEGUEN-Excel]

Glad that the video helps you 😉

[@LukmanHakim-rf8vv]

Thank your, Sir..

[@FredericLEGUEN-Excel]

You're welcome

[@sonu_kr]

saved my life thank you

[@FredericLEGUEN-Excel]

You're welcome 😊

[@mbaragamathieu4893]

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

[@FredericLEGUEN-Excel]

But now, XLOOKUP is more powerful

[@redone4605]

thank you very much

[@girliemorales-gera2124]

Do you have any sample so I can practice please

[@alysonsmith6743]

Thank you!

[@vipeensadawarte9042]

Thanks Mate !!!

[@elise7651]

Thanks, this helped me a lot!

[@stephinx]

Thanks

[@soumyajit112]

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

[@brolimba]

Thanks a lot...

[@FredericLEGUEN-Excel]

Your welcome

[@蓝鱼-s4h]

Saved my day, mate.

[@amitsharma-fw6cb]

Thanks a lottttt

[@Ycremotework]

Thank you :)

[@ayushjain-qs5ep]

lot of thanks. problem solved

[@FredericLEGUEN-Excel]

@@ayushjain-qs5ep you're welcome

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