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.
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.
Great and simple explanation! Tried doing it via the "help" window, but with no joy.. Thank you for making learning IFERROR straight forward easy!!! ^_^
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.
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
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.
You're absolutely right! In this instance I highlighted the entire table in case the person's table is different and they'd like to retrieve data from the last column :) Would rather include than exclude for the purpose of teaching Vlookup basics!
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
![일상 속 기분 좋음 [Proto disco meme]](http://i.ytimg.com/vi/DwmEIaZ7XGQ/mqdefault.jpg)
![ILLSLICK - THE KING'S LANDING [Freestyle]](http://i.ytimg.com/vi/feIJJnNkTfk/mqdefault.jpg)
Thank boss. I was struggling to learn this at work today, but I think I got it now.
Thank you so much! You deserve a like. It turned 150 hour job into 10 minute one. THANK YOU THANK YOU THANK YOU
Easy to understand very helpful 👍
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!
Perfect explanation! Thank you!
You saved my ass for my final exam. Thank you for this clear and excellent explanation !!!!
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.
Hahahaha sorry to disappoint! Maybe I should post a few more 😂 so happy you found this helpful :)
so much more helpful than the official training module given to me by my company!
Very very useful classes, thank you so much.
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.
Soooo AMAZING to hear! Good luck! :)
Thank you so much, it was so easy to follow the steps.
So welcome! :)
Great and simple explanation! Tried doing it via the "help" window, but with no joy.. Thank you for making learning IFERROR straight forward easy!!! ^_^
Thanks for the IFERROR with VLOOKUP its just what I needed!! Thanks again, you're a life saver.
Dimas Arias You’re so welcome! :)
heyshirls if I need any other help I’ll make sure to ask you since you seem to know what you’re doing. 👍🏽😂
Thank you so much. This tutorial is really 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.
You really made it very simple. It helped me!. Thank you!!
This is such a good and clear video, THANK YOU!
Aw thank you so much Jon! So happy it helped you!
I have more than one hour trying to solve IFERROR mystery, after viewing your video got it from the first time, thanks
Super welcome!!! :) I know Excel can be really tricky sometimes. So glad this helped you!
This video was so clean and well done. It helped me easily understand these functions. Thank you so much!
You are so welcome Ricky!! :)
Thank you so much for this. Helped me get through where I was stuck jn 😁
Glad that, I'm your 500th subscriber♥️
Awww thank you so much!
@@heyshirls your english accent, is so good! i love it, can you please make more excel videos? i just wanna listen your accent
This is a good and easily understood video, THANK YOU!
Johnny Chor So welcome!!!! :)
spot on... just what I needed. I have nice clean sheets now. Thanks
You're so welcome! :)))
YOU ARE AMAZING!!!! i subbed, I've been trying to learn this forever!
Awww I'm so happy to hear this helped you!!! :)
@@heyshirls thank you so much! I've been able to apply this great function to 2 spreadsheets for work and now I'm going to use it regarding my thesis
@@TheDrivenSoul You're so welcome! Best of luck with your thesis :)
@@heyshirls please make more videos
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
just to the point and perfect! Thanks :)
Thanks for sharing this video
Thanks this is so useful...
Thank you! Very clear and useful ☺️
good!. simple explanation
Thank you so much :)
Time savior thanks in advance 😍
Nice explanation 👍
Awesome explanation.
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.
you are amazing!!!
on point! thank you
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.
You're absolutely right! In this instance I highlighted the entire table in case the person's table is different and they'd like to retrieve data from the last column :) Would rather include than exclude for the purpose of teaching Vlookup basics!
Excellent!
PLEASE DO THE VIDEOS. EXCELLENT
Thank you!
well done
What if you know the answer is there? how do you find it?
I kept getting an error message on my VLOOKUP and I couldn't figure out why.
2:15 - 2:36 solved my problem.
finisher3x Yay! Amazing to hear :)
thank you
too good... let me subscribe :)
Iferror(vlookup ကိုသုံးပြီး date အလိုက် price change လုပ်ချင်လို့ ရလားရှင့်
thankss
What’s this for?
Oliver Yeh Hahahahahaha hey Ollie, this is for my journalism data assignment!
Where are you from?
❤️
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!