How To Use VLOOKUP and IFERROR in Excel 

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

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

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

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

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.

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

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

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.

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

Easy to understand very helpful 👍

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.

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

Very very useful classes, thank you so much.

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

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

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

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

YOU ARE AMAZING!!!! i subbed, I've been trying to learn this forever!

Perfect explanation! Thank you!

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

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

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

Thank you so much. This tutorial is really helpful

spot on... just what I needed. I have nice clean sheets now. Thanks

Thanks for sharing this video

Thank you! Very clear and useful ☺️

Thanks this is so useful...

just to the point and perfect! Thanks :)

Glad that, I'm your 500th subscriber♥️

Omg I really like this video , very detailed thanks . Can you do a video with the IFERROR(VLOOKUP) and HLOOKUP , and if it can be use to reference the pivot table data or does it have to reference the original data table , I’m not sure if Thats possible

Amazing and very practical

good!. simple explanation

Time savior thanks in advance 😍

you are amazing!!!

Awesome explanation.

on point! thank you

Nice explanation 👍

Thank you!

Excellent!

well done

PLEASE DO THE VIDEOS. EXCELLENT

thank you

Hey I Ran into another issue in excel. Is there any way to get a value to show on a 2nd sheet from sheet 1. Doing this while skipping all duplicate and using the next original value from the same column? My sheet 1 is never a constant amount of rows since im bringing in the data from an outside source so I could have 35 rows one day and 66 the next.

Not to be a stickler but you didn't have to include column D as part of your lookup table if you were not going to return data for Damage to Property.

Iferror(vlookup ကိုသုံးပြီး date အလိုက် price change လုပ်ချင်လို့ ရလားရှင့်

I kept getting an error message on my VLOOKUP and I couldn't figure out why. 2:15 - 2:36 solved my problem.

too good... let me subscribe :)

thankss

❤️

What if you know the answer is there? how do you find it?

Where are you from?

What’s this for?

What is the rush? It is very difficult to follow what you are saying because you are rushing through it. We get it you know your stuff but this is supposed to be a teaching video and rushing doesnt work when teaching. I would have taken a lot of marks off you for this

Great video, but your speaking way too fast.

Thank you!