Fix Excel VLOOKUP

No video

Fix Excel VLOOKUP

Рет қаралды 59,492

Excel Level Up

Күн бұрын

Пікірлер: 29

@nzajijanota7105 6 ай бұрын

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😂

@ExcelLevelUp 5 ай бұрын

You're welcome!

@merongirma6247 2 жыл бұрын

I can't thank you enough, after watching over 5 videos i found my error in this video. Thank you thank you!🙂

@mangkanor2901 3 жыл бұрын

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.

@ExcelLevelUp 3 жыл бұрын

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.

@pradeepkumarsharma8789 2 жыл бұрын

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

@ExcelLevelUp 2 жыл бұрын

I appreciate the comment and the view

@myamazinglife7025 2 жыл бұрын

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.

@ExcelLevelUp 2 жыл бұрын

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.

@maheshwarijhala4781 2 жыл бұрын

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

Thanks alot it helped solve my error. I will keep these 4 solutions in mind

@hhonestyh 2 жыл бұрын

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.

@ExcelLevelUp 2 жыл бұрын

I'm glad you were able to learn from the video. Good luck with Excel.

@judytan9062 3 жыл бұрын

Useful to what I was looking for.

@alanbejarano4940 7 ай бұрын

Numbervalue solved my issue!!!❤

@brycek2033 5 ай бұрын

Thanks!

@ExcelLevelUp 5 ай бұрын

Appreciate the tip.

@jelenamaksimovic3506 2 жыл бұрын

Awesome! Many thanks!

@manuelubaldo2314 2 жыл бұрын

My deepest thanks. Can i request a tutorial for how to fivot

@osamahalmarwai837 2 жыл бұрын

Great, thank you.

@Winter-yc4sw 2 жыл бұрын

Very good teacher

@ExcelLevelUp 2 жыл бұрын

Thank you

@brycek2033 5 ай бұрын

I LOVE YOU

@surajupadhyaya4336 3 жыл бұрын

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

@ExcelLevelUp 3 жыл бұрын

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.

@surajupadhyaya4336 3 жыл бұрын

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