Excel function VLOOKUP returns #N/A, why ? 4 examples

There are many reasons why VLOOKUP returns #N/A. This video will present the 4 common reasons why VLOOKUP returns N/A

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

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

[ボリヴァ]

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!! 👏👏👏👏👏👏👏

[binoymathew]

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.

[cloudcloud]

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 !

[deepikarajendran]

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

[ShahrukhKhan-trib]

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

[knoxvox]

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

[pauls]

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

[fatmaaslan]

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

[damilolaadeogun]

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 much!!!!

[MutebiBashir]

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

[mojdehhamedi]

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.

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

[talkbirds]

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

[adrianamiquilena]

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

[ashish-rs]

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

[biroti]

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

[Ravi-xfdw]

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

[aa-ggmv]

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

[Poojaverma-fvje]

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