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.
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.
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
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
![How To Apply VLOOKUP and XLOOKUP Formula on Large Data in Excel [Hindi] #excel](http://i.ytimg.com/vi/gAY9is-ahQY/mqdefault.jpg)
![How To Apply VLOOKUP and XLOOKUP Formula on Large Data in Excel [Hindi] #excel](/img/tr.png)
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 :)
You saved my ass for my final exam. Thank you for this clear and excellent explanation !!!!
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! :)
Great and simple explanation! Tried doing it via the "help" window, but with no joy.. Thank you for making learning IFERROR straight forward easy!!! ^_^
so much more helpful than the official training module given to me by my company!
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. 👍🏽😂
Easy to understand very helpful 👍
Thank you so much for this video! Helped me with a report I needed to process for work. LIFESAVER!
Perfect explanation! Thank 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!
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.
Thank you so much.
I was in need of such #N/A cases🎉
Good luck
Very very useful classes, thank you so much.
This video was so clean and well done. It helped me easily understand these functions. Thank you so much!
You are so welcome Ricky!! :)
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
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, it was so easy to follow the steps.
So welcome! :)
You really made it very simple. It helped me!. Thank you!!
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!!!! :)
Thank you so much. This tutorial is really helpful
Thank you so much for this. Helped me get through where I was stuck jn 😁
spot on... just what I needed. I have nice clean sheets now. Thanks
You're so welcome! :)))
Thank you! Very clear and useful ☺️
just to the point and perfect! Thanks :)
Amazing and very practical
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.
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
Thanks this is so useful...
good!. simple explanation
Thank you so much :)
Nice explanation 👍
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 :)
Awesome explanation.
Thanks for sharing this video
Time savior thanks in advance 😍
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!
you are amazing!!!
PLEASE DO THE VIDEOS. EXCELLENT
on point! thank you
What’s this for?
Oliver Yeh Hahahahahaha hey Ollie, this is for my journalism data assignment!
Iferror(vlookup ကိုသုံးပြီး date အလိုက် price change လုပ်ချင်လို့ ရလားရှင့်
What if you know the answer is there? how do you find it?
Where are you from?
Excellent!
well done
too good... let me subscribe :)
Thank you!
thank you
thankss
❤️
Great video, but your speaking way too fast.
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!
Thank you!