I cannot thank you enough, my friend! You have just shown me my error, after repeating the right formula over and over again. It was driving me crazy😂
@ExcelLevelUp5 ай бұрын
You're welcome!
@merongirma62472 жыл бұрын
I can't thank you enough, after watching over 5 videos i found my error in this video. Thank you thank you!🙂
@mangkanor29013 жыл бұрын
This is totally awesome for begginers like me. Just hire as a freight VA and i have a lot of data to file up to save time.. this is perfect.
@ExcelLevelUp3 жыл бұрын
Glad you enjoyed it. Let me know if I can make other videos that you could use. What is a freight VA? I haven’t heard of that role before.
@pradeepkumarsharma87892 жыл бұрын
Thanks for this video I have searched everywhere but didn’t found out anyone who explained them with specific example . It helped me a lot
@ExcelLevelUp2 жыл бұрын
I appreciate the comment and the view
@myamazinglife70252 жыл бұрын
This has been more helpful to me than any other video, or class on this subject! Thank you for the effort, and for sharing your knowledge.
@ExcelLevelUp2 жыл бұрын
Great to hear! my channel is about sharing what I know and I frequently (always) learn from viewers who offer other ideas. Excel usually has several options to achieve your desired results.
@maheshwarijhala47812 жыл бұрын
Thank You. This video was very helpful and I could solve the errors in 5 minutes. Please keep making such videos.
@binoymathew8663 Жыл бұрын
Thank you so much for putting the solutions in the description as well. It helped me quickly pick up 'Mismatch data types (Google Sheets): =VLOOKUP(VALUE(B4),E:F,2,0) ' and my life just became easier. Thanks again
@susan.samson3 жыл бұрын
Thanks alot it helped solve my error. I will keep these 4 solutions in mind
@hhonestyh2 жыл бұрын
thank you so much, this was very helpful. i was getting #N/A for a couple of years and could not figure out the formula.
@ExcelLevelUp2 жыл бұрын
I'm glad you were able to learn from the video. Good luck with Excel.
@judytan90623 жыл бұрын
Useful to what I was looking for.
@alanbejarano49407 ай бұрын
Numbervalue solved my issue!!!❤
@brycek20335 ай бұрын
Thanks!
@ExcelLevelUp5 ай бұрын
Appreciate the tip.
@jelenamaksimovic35062 жыл бұрын
Awesome! Many thanks!
@manuelubaldo23142 жыл бұрын
My deepest thanks. Can i request a tutorial for how to fivot
@osamahalmarwai8372 жыл бұрын
Great, thank you.
@Winter-yc4sw2 жыл бұрын
Very good teacher
@ExcelLevelUp2 жыл бұрын
Thank you
@brycek20335 ай бұрын
I LOVE YOU
@surajupadhyaya43363 жыл бұрын
In case of a continual database autoupdate, N/A also gets displayed if an entire row is missing or added automatically.Could you please tell how to adjust so that you don't have to manually add or remove the entire missing row during each data update? Thanks
@ExcelLevelUp3 жыл бұрын
I would recommend wrapping the VLOOKUP statement within a IFERROR statement. IFERROR will return whatever value you want (blank, any word or phrase) when a match is not found instead of N/A.
@surajupadhyaya43363 жыл бұрын
@@ExcelLevelUp Thank you! :) pls also mention how to pull data from a website having multiple pages, especially when you can see the data broken down into different pages in the same url address but only partial data or no data is imported into excel...especially while pulling data from websites ending with aspx
@saifrashid67136 ай бұрын
No space, No missing data, same data type and with exact match. Still vlookup is giving #N/A eroor. Its very annoying......
@ExcelLevelUp5 ай бұрын
Check out my “2 minute fix for N/A errors”. Excel cannot always tell if your values are letters or numbers. This video will help with that.