Why My Vlookup Function Does Not Work?

New course Launched! I created it to show you step-by-step how to design a salary structure with regression analysis in Excel. Check out the detail here:

Business Scenario: fix the common errors we see in applying Vlookup function for data analysis
This video summarizes 4 common errors in the "vlookup" function:
1. Not using absolute cell reference
2. Vlookup numbers as text
3. Vlookup numbers that are not equal
4. Vlookup text that are not equal

-~-~~-~~~-~~-~-
Please watch: "5 Vlookup Errors in Complex Formula and How to Check Step by Step"
-~-~~-~~~-~~-~-

******Follow-up Consulting Services******

******More Videos in Playlists******

#ExcelforHR#HRAnalytics#Excel#HR

[rkeough]

I can not thank you enough, you solved days of bashing my head against the wall.

[MzKemmieAdeniji]

My case was the numbers not being equal and I would never have figured it out on my own!! Thank you for showing the trim function too!

[harrisonc]

This video quite honestly changed my life. Thank you

[TrustySource]

I watched several videos on VLookup and couldn't get my function to work ... This video fixed my problems. THANK YOU!

[ld]

You have summarised the issues and solutions of pivot table so succinctly. Well done and you cut to the chase...this is so good..

[ld]

Im surprised you are not getting more than100k likes for this great tutorial. You explain it well and to the point. Keep to this style.. Another possitive feedback is you zoom it enough to be readable unlike some others. I dont why why anyone would thumbs down on this

[noahniederklein]

Thank you so much, I was using "4" instead of 4, etc. and had no idea that impacted vlookup (and hlookup, which I was using at the time, but vlookup is more popular)

[potatoftw]

Thanks very much!!!! I really appreciate this video as I wasted too much time trying to figure out whats wrong!, turned out there was a hidden decimal I wasn't aware off!! Thanks again!

[rashmisinha]

This was excellently explained in simple words: How to fix the common errors specially with use of LEN and TRIM function was very helpful. YOu have exceuted the video in very easy to understand language. God bless you!!

[VR-zhlo]

Thank you. This was very helpful. I could not understand why my lookups where not working. The length was the issue.
I also learnt a new formula from you - trim.

[PranayDeepSure]

The last technique saved my ass at work. Thanks a ton!

[Jojosmith]

Thank you so much for your valuable tutorial. I used the same formula that works fine but the 2nd time, it did not return the expected results. It was because of the data type I need to convert the same. Subscirbed & definately liked 👍

[GhulamKarim-su]

i was stuck with same issue in office thank you for sharing

[syriamacariola]

THANK YOU SO MUCH!!! Been wonder for about 6 mos why mine's not working. Big help! 🤗

[DoenyInJapan]

Finally, I've found the solution to my vlookup problem.

[alsefati]

Thanks, this was helpful. It was driving me nuts

[sulja]

Bingo! Your first tip saved a lot of my time. That's where I was struggling g with. Thank you so much🙂

[amelianovita]

THANK YOU SO MUCH, MADAM!
YOU ARE MY SAVIOR! I can't believe I found this video and figured out my problem doing vlookup.

Once again, thank you very much! <3

[emchinna]

It worked for me. Thanks gor saving so much of time and i was unable to figure out. Thanks a lot.

[ranjannayak]

Great Videos...Really Appreciated. It would be really helpful if u can share the datasets used in the videos...Thanks a ton in advance....