Why My Vlookup Function Does Not Work?

Рет қаралды 172,779

7 жыл бұрын

Want to learn how to design a salary structure? Check: www.caripros.com/design-salar...
FREE template for my video: Excel for HR - Create Annual Employee Salary Increase Template from Scratch. You can download and try it out yourself here: bit.ly/2MLLdb7
FREE actual workbook for my video "Split a Master Spreadsheet into Multiple Sheets with 1 click - VBA for Beginner". You can download and try it out yourself here: bit.ly/2UmeX2v
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:
caripros-hr-analytics.teachab...
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"
• Excel Troubleshooting ...
~-~~-~~~-~~-~
*****Follow-up Consulting Services*****
If you have specific question regarding your issue, you can email me at the email here goo.gl/WejijZ Note that there will be a fee of US$200 charged for solving your issue. The turnaround is within 24 hours. Any follow-up issue in 3 days will also be answered with no charge. Payment link: www.paypal.me/caripros
*****More Videos in Playlists*****
Power BI for Beginners: bit.ly/3ivKitD
Power BI for Advanced Users: bit.ly/3lE9zmO
Excel for HR goo.gl/JdeVnd
Excel for HR - Master Class goo.gl/LYfq2f
Excel Macro - Beginner goo.gl/Yae5nc
Excel Macro/VBA - Splitting a Master File goo.gl/m8CHya
Excel Macro/VBA - Auto-hide Rows or Columns bit.ly/2Mzteb5
Excel Charts Data Visualization goo.gl/2ao6BP
Excel Vlookup Function goo.gl/kP2Wpz
Excel Pivot Table Function goo.gl/rukkPs
Excel Array Function goo.gl/i4sQH8
Excel Index and Match Function goo.gl/i7VGU4
Excel Solver/Goal Seek Functions goo.gl/FTkTnj
Excel Cell Formatting Solutions goo.gl/gpa6MY
HR Analytics - Merit Matrix goo.gl/Koy7co
HR Analytics - Salary Structure goo.gl/uZBnFa
Excel Tricks goo.gl/TeqGDw
Excel Troubleshooting goo.gl/bdY5by
Fun HR Topics goo.gl/7zVg8h
For more successful stories, view at: caripros.com/index.php/success...
#ExcelforHR#HRAnalytics#Excel#HR

Пікірлер: 96

@CariprosHRAnalytics 5 жыл бұрын

I have made one more video on Vlookup troubleshooting help solving your problem. Check it out: kzfaq.info/get/bejne/pq-SlKub3q3YYZs.html

@ranjannayak99 2 жыл бұрын

Hi kindly help me with the datasets used in the videos....

@rkeough8 2 жыл бұрын

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

@ld1622 4 жыл бұрын

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

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

@TrustySource 4 жыл бұрын

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

@sulja786 3 жыл бұрын

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

@noahniederklein8081 4 жыл бұрын

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)

@ld1622 4 жыл бұрын

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

@CariprosHRAnalytics 4 жыл бұрын

Thank you I appreciate it! Will try my best to keep it up!

@rashmisinha4447 3 жыл бұрын

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-zh7lo 3 жыл бұрын

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.

@potatoftw355 9 ай бұрын

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!

@errolm8313 5 жыл бұрын

What about when the len output matches and there is still an error in vlookup?

@damionsmith3295 2 жыл бұрын

Does the value you're looking up have to be placed in the first column of table index?

@alsefati8839 Жыл бұрын

Thanks, this was helpful. It was driving me nuts

@emchinna 3 жыл бұрын

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

@swathih1 4 жыл бұрын

Thank you for sharing!! My Vlookup was crazy, because of 2000 lines of data. This might fix some issues.

@sakshiverma8628 4 жыл бұрын

I have clearly mentioned two workbooks. Two different workbooks are already opened and I am trying to VLookUp there I have selected Lookup value in one workbook then for look array I switch to another workbook but the VLook function is not showing in another workbook. Can someone help me with that?

@Zune499 2 жыл бұрын

You saved me a lot of time. Thanks!

@Jojosmith342 Жыл бұрын

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 👍

@webslinger2011 4 жыл бұрын

This helped a lot! Thanks!

@NAtwal-wv4sn 4 жыл бұрын

Great tips!! Thank you!

@aaaaaaaaa7867 3 жыл бұрын

Super Thanks! So Helpful.

@najamulhassan4852 Жыл бұрын

Nicely explained, kudos to you😊

@ConndorBoy 4 жыл бұрын

Thank you, you saved my life!

@ranjannayak99 2 жыл бұрын

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

@MysteryRPR 4 жыл бұрын

a big issue solved , thank you very much for the help, i am seeing only 4 in the selected cell for the name and with len function its 10 , manually changed name, and the issue solved , thanks alot for the video

@syriamacariola1704 Жыл бұрын

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

@cheriprincess 6 жыл бұрын

I've been searching for solutions to my problem to Vlookup. Thank you so much! This video really helped me a lot :) God Bless :)

@PranayDeepSure Жыл бұрын

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

@kumararun8337 Жыл бұрын

thank you 😊, I finally got it working after seeing this vedio.

@RamRam-ce2yk 2 жыл бұрын

Thank you so much , This video helping me a lot ❤️❤️

@gayathrikavindya 2 жыл бұрын

Thank you this was really helpful

@EazyDaLegend 3 жыл бұрын

Really helpful, thanks a lot!

@rohanshxtty 2 жыл бұрын

thanks, this saved me a ton of time

@theakruger4714 2 жыл бұрын

Great video - Thank you

@tiangehou9154 5 жыл бұрын

Thank you so much, this video helps a lot

@IamMumbhai Жыл бұрын

Thanks your absolute reference saved me many hours

@motupallichaitanya3775 4 жыл бұрын

thank you so much...i love you..you made my life easy

@antoniofady 3 жыл бұрын

Superb !! thanks., i learnt something new todat because of you !! God bless

@bigliss9040 4 жыл бұрын

Thank you for this information. You are an angel!!!

@CariprosHRAnalytics 4 жыл бұрын

Glad it was helpful!

@Fallinginsound 3 жыл бұрын

Thank you so much, I was going crazy.

@tsengel1793 3 жыл бұрын

on my laptop, the comma that is between the cells are appearing as dots and the cells colors (like C11 in blue in 0:31) become just black. How to fix it and is effecting vlookup function cause i cant use vlookup. Please help me

@sahdysagaly9297 3 жыл бұрын

Thank you , i learned some thing new, respect

@aniket559 3 жыл бұрын

Very helpfull. Thank you so much

@victoriaadu6299 11 ай бұрын

thank you very helpful! Had to convert my text to number!

@Sara-k0020 3 жыл бұрын

Thanks for the help !! 👍

@pantherkursk 2 жыл бұрын

thanks for teaching us - thanks thanks

@venkatramana8966 4 жыл бұрын

Thank u so much for excellent point of explanation

@himanshusahoo6536 4 жыл бұрын

Great tips!

@amelianovita8235 4 жыл бұрын

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!

@sipsip2367 2 ай бұрын

great video thank you very much

@dhashennaidu6116 2 жыл бұрын

Thanks for the assist.

@adibahnurulyunisya7814 Жыл бұрын

THANK YOU!

@kevilneer6256 3 жыл бұрын

thank you very much! :)

@sktechnicalsajidali2512 4 жыл бұрын

Sir mera ms office 2007 open kerte hi or uske text mai click kerte hi all feature not working ab kiya kara jaye please help me

@joyceojeiwa6987 6 жыл бұрын

Hi, thank you so much for this video very helpful. Is there any other reason one might still be getting #N/A in exact match VLOOKUP, I tried all the options you provided but I am still having trouble getting the exact match to work while leaving that cell empty always returns a value but I need to be sure which is why I am hung up on the exact match error.

@CariprosHRAnalytics 6 жыл бұрын

Hi Joyce - Have you checked my other video that discusses more vlookup errors? it's kzfaq.info/get/bejne/pq-SlKub3q3YYZs.html&list=PLLBzkESv1Bg4oKfbybcMIi4PeV00CYcJR&index=7 Let me know if still not working! Hope it's helpful!

@CALeduc-lj4pw 4 жыл бұрын

To those who are still getting an Error message: VLOOKUP does not work between different types of data (extract a fiscal period if you look up its reference date). The DGET function helped me in this case. Look up DGET tutorial videos, and you can add 'sheet name' (and hide the tab if you wish).

@amaanliaquat7466 2 жыл бұрын

Thank you ❤️ so much

@shanu7703 3 жыл бұрын

Thank you very much

@ewilson378 5 жыл бұрын

Hi Caripros, I've been struggling with Vlookup not working for a large file, and recreated one smaller with fewer columns. I've followed your recommendations and ensured that all the data is the same format, but still no luck. Please help. I can send you file I created if you'd like to take a look and see what I'm doing wrong?

@CariprosHRAnalytics 5 жыл бұрын

Sure you can send to my email hr@caripros.com. I will take a look =)

@subrat49 3 жыл бұрын

thank you very very very very very again very much.

@donie5828 Жыл бұрын

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

@Dimi000 Жыл бұрын

THANK YOU

@royale4004 5 жыл бұрын

thank you this help me alot

@CariprosHRAnalytics 5 жыл бұрын

Nice to know!

@thealgerianmyth1060 2 жыл бұрын

Thanx luv

@pablogomez631 5 жыл бұрын

Thanks!!

@KobeFootball 3 жыл бұрын

TYSM

@babu1024 3 жыл бұрын

Just...g8....best one

@prashantkiratkar.5747 3 жыл бұрын

LIFE SAVER!!!!! :-O

@gilsontorquato9091 5 жыл бұрын

You are great

@rajugoud1563 Жыл бұрын

Super mam

@myronkane5402 Жыл бұрын

You're not showing us how to do Absolute Reference.

@linuswaghmare538 4 жыл бұрын

Thanks

@Chongweisingapore 3 жыл бұрын

u are v power

@anaruzdihya1237 6 жыл бұрын

Thank you :)

@CariprosHRAnalytics 6 жыл бұрын

My pleasure Anaruz! =)

@anaruzdihya1237 6 жыл бұрын

I have a question😊 How can we put parentheses around one number in cell ( only one cell)using a one keyboard shortcut? Instead of using shift key + “(“ to open the parentheses and shift key + “)” to close the parentheses. Thank you:)

@CariprosHRAnalytics 6 жыл бұрын

Hi Anaruz, you raised a very good question. It never occurred to me as I have always been using this typical method, but I do know that for some programming language, you are able to input "(" and "()" will auto-populate and it is better than the manual input to prevent formula error. So I then searched online and multiple sources confirmed that no, Excel does not have such function or shortcut. (answers.microsoft.com/en-us/mac/forum/macoffice2011-macexcel/excel-shortcut-for-brackets-in-a-formula/bf59b8e6-7622-4f40-b7b0-13bf5c69827c?auth=1) ...Although you may use custom keystroke or auto-correction to make "()" appear in an Excel cell, but it is really not more productive in any way as I tested. This is all that I know now. If you find some more creative solution please let me know! =P

@anaruzdihya1237 6 жыл бұрын

I appreciate your time :)