How To Use VLOOKUP and IFERROR in Excel

Hey guys!

I made this video for a data journalism assignment at uni. This is a basic tutorial on how to use the VLOOKUP and IFERROR function in excel. The VLOOKUP function allows you to locate data in tables and large datasets by using a specific value as a reference point. On the other hand, the IFERROR function is useful for customising a response when Excel evaluates an error (in this case, #N/A errors that appear when the VLOOKUP function cannot find the value you have specified).

Hope you find this tutorial helpful!

[MohitKumar-chfn]

Thank you so much.
I was in need of such #N/A cases🎉
Good luck

[toghrulaliyev]

Thank you so much! You deserve a like. It turned 150 hour job into 10 minute one. THANK YOU THANK YOU THANK YOU

[EH-spwk]

Thank boss. I was struggling to learn this at work today, but I think I got it now.

[MrsBenjamin]

Thank you so much for this video! Helped me with a report I needed to process for work. LIFESAVER!

[Ab-mxbj]

You saved my ass for my final exam. Thank you for this clear and excellent explanation !!!!

[mauriceprice]

I was dreading learning this as I thought it would be really tough. Thanks to you I got it first go. Brilliant! I won't look like a hopeless case at my new job now.

[Piner]

I just looked up your page for more excel because this vid was easy to follow and well explained. Come to find out this was just an assignment for journalism. lol..This was GREAT! Thanks for making it simple for me.

[valentinrobles]

Great and simple explanation! Tried doing it via the "help" window, but with no joy.. Thank you for making learning IFERROR straight forward easy!!! ^_^

[abohazemalshaikh]

I have more than one hour trying to solve IFERROR mystery, after viewing your video got it from the first time, thanks

[ericbell]

so much more helpful than the official training module given to me by my company!

[georgewick]

Thank you so much for this. Helped me get through where I was stuck jn 😁

[Rajan-kknl]

Very very useful classes, thank you so much.

[snuckumsss]

Very helpful love, I appreciate your video, easy to understand and straight to the point. I also the tips you added with locking your spreadsheet, and the dollar signs, very useful.

[namasebo]

Thank you so much, it was so easy to follow the steps.

[RaviDevgam]

You really made it very simple. It helped me!. Thank you!!

[dimasarias]

Thanks for the IFERROR with VLOOKUP its just what I needed!! Thanks again, you're a life saver.

[thesecretlifeofaloner]

Thank you so much. This tutorial is really helpful

[guasabara]

This is such a good and clear video, THANK YOU!

[rickyly]

This video was so clean and well done. It helped me easily understand these functions. Thank you so much!

[Cwhj]

This is a good and easily understood video, THANK YOU!