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.
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.
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
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.
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 :)
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!
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. 👍🏽😂
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 for this video! Helped me with a report I needed to process for work. LIFESAVER!
so much more helpful than the official training module given to me by my company!
You saved my ass for my final exam. Thank you for this clear and excellent explanation !!!!
Thank you so much.
I was in need of such #N/A cases🎉
Good luck
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
@@SilverSoulZ58 You're so welcome! Best of luck with your thesis :)
@@heyshirls please make more videos
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
Easy to understand very helpful 👍
This video was so clean and well done. It helped me easily understand these functions. Thank you so much!
You are so welcome Ricky!! :)
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.
Perfect explanation! Thank you!
Very very useful classes, thank you so much.
Thank you so much, it was so easy to follow the steps.
So welcome! :)
Thank you so much for this. Helped me get through where I was stuck jn 😁
This is such a good and clear video, THANK YOU!
Aw thank you so much Jon! So happy it helped you!
Thank you so much. This tutorial is really helpful
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 really made it very simple. It helped me!. Thank you!!
Amazing and very practical
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
Time savior thanks in advance 😍
just to the point and perfect! Thanks :)
Thanks this is so useful...
good!. simple explanation
Thank you so much :)
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.
Thanks for sharing this video
Thank you! Very clear and useful ☺️
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 :)
Iferror(vlookup ကိုသုံးပြီး date အလိုက် price change လုပ်ချင်လို့ ရလားရှင့်
Nice explanation 👍
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!
Awesome explanation.
you are amazing!!!
on point! thank you
Excellent!
PLEASE DO THE VIDEOS. EXCELLENT
What if you know the answer is there? how do you find it?
well done
thank you
Thank you!
too good... let me subscribe :)
❤️
thankss
Where are you from?
What’s this for?
Oliver Yeh Hahahahahaha hey Ollie, this is for my journalism data assignment!
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!