Excel function VLOOKUP returns

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

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

50% 1

There are many reasons why VLOOKUP returns #N/A. This video will present the 4 common reasons why VLOOKUP returns N/A
More examples in this article excel-tutorial.com/why-vlooku...
00:00 Presentation situation 1
00:38 Presentation situation 2
00:57 Presentation situation 3
01:26 Presentation situation 4
02:09 Situation wrong values
04:23 Situation approximate match
07:40 Wrong selection of data
09:15 Multiple keys
#vlookup #n/a #excel

Опубликовано:

8 авг 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@El_bigC 3 года назад

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 3 года назад

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

@codak29 4 года назад

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

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

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 2 года назад

Thanks a lot ❤️

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

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

Thanks for your very nice message 😊

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

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

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

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

@1knoxvox 3 года назад

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

@theodule01 3 года назад

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

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

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

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

@prashantkiratkar.5747 3 года назад

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

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

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

@ShahrukhKhan-tr5ib 2 года назад

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

@JERosa86 3 года назад

Amazing! thank you sir!

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

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

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

Thank you Sir, have been looking!

@Poojaverma-fv8je Год назад

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

@mahdihanifi5408 3 года назад

really helpful

@aa-gg9mv 2 года назад

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

@FredericLEGUEN-Excel 2 года назад

Thanks 😊

@soumyajit112 4 года назад

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

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

Helped a lot. Thanks for sharing the lock function

@FredericLEGUEN-Excel 11 месяцев назад

You're welcome

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

Amazing!

@elise7651 4 года назад

Thanks, this helped me a lot!

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

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

@FredericLEGUEN-Excel 10 месяцев назад

Thanks you so much for your message 😊

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

This video helped me also! Thanks a lot

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

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

@FredericLEGUEN-Excel 11 месяцев назад

Thanks for your message 😊

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

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

@talk2birds128 3 года назад

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

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

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

Which situation solves your problem?

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

@@FredericLEGUEN-Excel example 2

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

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

@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

@Ravi-xf8dw 2 года назад

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 2 года назад

Thanks a lot 😁

@richardkamoche924 5 лет назад

Thanks problem solved thanks

@alysonsmith6743 4 года назад

Thank you!

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

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 2 года назад

Thanks a lot for your message 😃

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

thank you for this video,

@FredericLEGUEN-Excel 10 месяцев назад

You're welcome 😃

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

Thank You!

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

thank you very much

@user-mw6xl3lo7n Год назад

Saved my day, mate.

@Ycremotework 4 года назад

Thank you :)

@mmak9553 4 года назад

Thanks...

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

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

@FredericLEGUEN-Excel 2 года назад

Glad that the video helps you 😉

@vipeensadawarte9042 3 года назад

Thanks Mate !!!

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

thanks man you saved my knuckles and screen

@FredericLEGUEN-Excel 2 года назад

Glad it helps you 😉

@LukmanHakim-rf8vv 2 года назад

Thank your, Sir..

@FredericLEGUEN-Excel 2 года назад

You're welcome

@girliemorales-gera2124 4 года назад

Do you have any sample so I can practice please

@koolron100 Год назад

Thankyou you saved my time

@FredericLEGUEN-Excel Год назад

You're welcome 😉

@amitsharma-fw6cb 2 года назад

Thanks a lottttt

@stephinx 3 года назад

Thanks

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

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

@FredericLEGUEN-Excel 4 месяца назад

Thanks for your comment 😃👌

@ayushjain-qs5ep Месяц назад

lot of thanks. problem solved

@FredericLEGUEN-Excel Месяц назад

@@ayushjain-qs5ep you're welcome

@brolimba 3 года назад

Thanks a lot...

@FredericLEGUEN-Excel 3 года назад

Your welcome

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

Thank-you, you saved a sleepless night.

@nbent4607 3 года назад

Real heroes don't wear capes!!!

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

saved my life thank you

@FredericLEGUEN-Excel 2 года назад

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

@QFGEE 3 года назад

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

@FredericLEGUEN-Excel 3 года назад

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 2 года назад

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

@charlesperich2480 3 года назад

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 3 года назад

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