Why My Vlookup Function Does Not Work?
ฝัง
- เผยแพร่เมื่อ 28 ส.ค. 2024
- Want to learn how to design a salary structure? Check: www.caripros.c...
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-an...
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/...
*****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/in...
#ExcelforHR#HRAnalytics#Excel#HR
I have made one more video on Vlookup troubleshooting help solving your problem. Check it out: th-cam.com/video/pIbaHjyGt1g/w-d-xo.html
Hi kindly help me with the datasets used in the videos....
I can not thank you enough, you solved days of bashing my head against the wall.
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!
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
Thank you I appreciate it! Will try my best to keep it up!
I watched several videos on VLookup and couldn't get my function to work ... This video fixed my problems. THANK YOU!
i was stuck with same issue in office thank you for sharing
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)
You have summarised the issues and solutions of pivot table so succinctly. Well done and you cut to the chase...this is so good..
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!
The last technique saved my ass at work. Thanks a ton!
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.
You saved me a lot of time. Thanks!
Thanks, this was helpful. It was driving me nuts
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!!
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 👍
Finally, I've found the solution to my vlookup problem.
thank you 😊, I finally got it working after seeing this vedio.
thank you very helpful! Had to convert my text to number!
THANK YOU SO MUCH!!! Been wonder for about 6 mos why mine's not working. Big help! 🤗
Nicely explained, kudos to you😊
thanks, this saved me a ton of time
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).
It worked for me. Thanks gor saving so much of time and i was unable to figure out. Thanks a lot.
Thank you for sharing!! My Vlookup was crazy, because of 2000 lines of data. This might fix some issues.
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?
Bingo! Your first tip saved a lot of my time. That's where I was struggling g with. Thank you so much🙂
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!
thanks for teaching us - thanks thanks
Thank you so much ,
This video helping me a lot ❤️❤️
Super Thanks! So Helpful.
Thanks your absolute reference saved me many hours
Superb !! thanks., i learnt something new todat because of you !! God bless
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
I've been searching for solutions to my problem to Vlookup. Thank you so much! This video really helped me a lot :) God Bless :)
Great Videos...Really Appreciated. It would be really helpful if u can share the datasets used in the videos...Thanks a ton in advance....
What about when the len output matches and there is still an error in vlookup?
Thank you this was really helpful
Thanks for the assist.
Thank you, you saved my life!
great video
thank you very much
Great video - Thank you
Very helpfull. Thank you so much
thank you very very very very very again very much.
THANK YOU!
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
Thank you so much, I was going crazy.
Thank you , i learned some thing new, respect
Thank you for this information. You are an angel!!!
Glad it was helpful!
thank you very much!
:)
Just...g8....best one
Does the value you're looking up have to be placed in the first column of table index?
Thank you ❤️ so much
Thank u so much for excellent point of explanation
Great tips!! Thank you!
This helped a lot! Thanks!
thank you so much...i love you..you made my life easy
You're not showing us how to do Absolute Reference.
Thanks for the help !! 👍
Really helpful, thanks a lot!
Thank you very much
THANK YOU
Thank you so much, this video helps a lot
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
Great tips!
Super mam
Thanx luv
TYSM
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?
Sure you can send to my email hr@caripros.com. I will take a look =)
thank you this help me alot
Nice to know!
u are v power
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.
Hi Joyce - Have you checked my other video that discusses more vlookup errors? it's th-cam.com/video/pIbaHjyGt1g/w-d-xo.html&list=PLLBzkESv1Bg4oKfbybcMIi4PeV00CYcJR&index=7
Let me know if still not working! Hope it's helpful!
Thanks
Thanks!!
LIFE SAVER!!!!! :-O
You are great
And when Excel and VLOOKUP still not work comparing numbers then WHAT??
hi Did you check my other Vlookup troubleshooting video?
Thank you :)
My pleasure Anaruz! =)
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:)
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
I appreciate your time :)
👏👏
U r awesome
Thank you Dara!
Excel SUCKS!! You can use the same vlookup method for months and then... poof it decides not to work.
YEP!!!!!!!!!!!!!!!!!!!!!!!!! FUCK BILL GATES AND MICROSOFT.