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)
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).
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!
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
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
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?
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.
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 👍
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!!
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
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!
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?
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!
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
![ค้าง (STILL) - GEMINI [ OFFICIAL MV ]](http://i.ytimg.com/vi/Ftxx3hk5vkU/mqdefault.jpg)
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!
This video quite honestly changed my life. Thank you
I watched several videos on VLookup and couldn't get my function to work ... This video fixed my problems. THANK YOU!
You saved me a lot of time. Thanks!
The last technique saved my ass at work. Thanks a ton!
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..
i was stuck with same issue in office thank you for sharing
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).
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!
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!
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
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?
Nicely explained, kudos to you😊
Thanks, this was helpful. It was driving me nuts
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.
Finally, I've found the solution to my vlookup problem.
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 👍
It worked for me. Thanks gor saving so much of time and i was unable to figure out. Thanks a lot.
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!!
thanks, this saved me a ton of time
thank you very helpful! Had to convert my text to number!
Thanks your absolute reference saved me many hours
Super Thanks! So Helpful.
THANK YOU SO MUCH!!! Been wonder for about 6 mos why mine's not working. Big help! 🤗
Thank you, you saved my life!
Great Videos...Really Appreciated. It would be really helpful if u can share the datasets used in the videos...Thanks a ton in advance....
thank you 😊, I finally got it working after seeing this vedio.
Does the value you're looking up have to be placed in the first column of table index?
Thank you this was really helpful
What about when the len output matches and there is still an error in vlookup?
Superb !! thanks., i learnt something new todat because of you !! God bless
This helped a lot! Thanks!
Great tips!! Thank you!
I've been searching for solutions to my problem to Vlookup. Thank you so much! This video really helped me a lot :) God Bless :)
Hi, I tried many time using your method but I still cannot solve, only can find the 3 value wanted out of 10. Do you have any solution?
Thank you for sharing!! My Vlookup was crazy, because of 2000 lines of data. This might fix some issues.
Great video - Thank you
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 ,
This video helping me a lot ❤️❤️
thanks for teaching us - thanks thanks
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
Thank you for this information. You are an angel!!!
Glad it was helpful!
Very helpfull. 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!
Really helpful, thanks a lot!
Thank you so much, I was going crazy.
Thank you , i learned some thing new, respect
Thanks for the assist.
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!
Thank u so much for excellent point of explanation
Thanks for the help !! 👍
great video
thank you very much
thank you so much...i love you..you made my life easy
THANK YOU!
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 =)
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!
Thank you so much, this video helps a lot
thank you very very very very very again very much.
Just...g8....best one
Thank you ❤️ so much
thank you very much!
:)
Thank you very much
THANK YOU
thank you this help me alot
Nice to know!
You're not showing us how to do Absolute Reference.
Thanx luv
Thanks
Thanks!!
LIFE SAVER!!!!! :-O
TYSM
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.
Super mam
You are great
u are v power
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 :)
And when Excel and VLOOKUP still not work comparing numbers then WHAT??
hi Did you check my other Vlookup troubleshooting video?
U r awesome
Thank you Dara!
👏👏