How to Pull Data into Excel Reports from Another Spreadsheet with VLOOKUP and XLOOKUP

[@02nicwalk]

OMG! Your videos explain very clearly how to both formulas. I have struggled for years. So keep them coming.

[@SharonSmith]

So glad you found my videos helpful! Thanks for watching!

[@isabelleayotte7267]

I've never been able to actually succeed with Vlookup and XLookup, the exemples you use are so applicable to my work that it makes it easier to grasp the concept of moving data - you're videos are great! Thank you.

[@SharonSmith]

I'm so glad to hear that! It is always easier to learn when the examples are relevant to your work. I'm so glad you found my Channel and that my videos are helpful for you. Thanks so much for taking time to leave a nice comment and for watching my videos!

[@taetaesub9254]

This is the only video that made me do this easily. You have no idea how you have helped me. All the other videos are just explaining unnecessary things and don't really show exactly like this! Thank you so much ❤

[@SharonSmith]

That is a great compliment! Thank you so much. I’m so glad you found my video helpful!

[@m1dwestmale]

THANK YOU SHARON!! I also watched several tutorials on how to use VLOOKUP as you described, and not being familiar with its use, it TOTALLY WORKED! You explained it best for me to understand and use on my own. THANK YOU! THANK YOU! THANK YOU!

[@SharonSmith]

I'm so glad to hear you found my video helpful and you were able to successfully use VLOOKUP! That is awesome! Thanks so much for taking time to leave a nice comment and thanks for watching my videos!

[@Petitecharmdiaries]

Your videos are best. No one made vlookup so easy. Thanks a lot

[@SharonSmith]

I'm so glad to hear that! Glad you found it helpful. Thanks for watching!

[@Damon94Z28]

This is going to save me so much time on Friday's at work! And who doesn't want to save time on a Friday at work?! :)

[@SharonSmith]

That is awesome! Glad you found it helpful! Happy Friday!

[@Adam-zy4lj]

Great job and to the point explanation , thank you very much my dear👍👍👍 , warm greetings from Yemen Country

[@SharonSmith]

So glad you found it helpful! Thanks for watching!

[@yusufopeyemi7309]

Brief but straight to the point..I found it really helpful

[@SharonSmith]

I’m so glad you found this video helpful! Thanks for watching!

[@BlackRussian0795]

Wow!!! thank you so much!!! So clear, concise, and easy to understand.

[@SharonSmith]

I'm so glad to hear that! Thanks for watching my videos!

[@Rapunzella]

X lookup worked great for me. Thanks!

[@SharonSmith]

Great to hear! Thanks for watching!

[@j.r.61]

Incredibly helpful!! I will be using this today!!

[@SharonSmith]

That is great to hear! Thanks for watching!

[@samanmaeruf]

I watched a lot of tutorials... you are the best, thank you very much my dear

[@SharonSmith]

I'm so glad to hear that! Thanks for watching my videos!

[@FredJumayao]

You are so awesome! Thanks, been meaning to learn how to use these functions, but now that I have a need I'm forced to learn it, lol. Yours was the first video I found and you explained it so clearly and succinctly.

[@SharonSmith]

I’m so glad you found it helpful! Once you learn these functions you’ll use them a lot! Best of luck to you! Thanks for watching my videos!

[@selhadinabdibeker8216]

I have never given a comment on KZbin. you are the first. you really saved me from 3 days of work, thank you so much, tag me in your videos, I will give it a big like always.

[@SharonSmith]

Thanks so much for your nice comment! I'm so glad you found my videos helpful. Thanks for watching! Best of luck to you!

[@JeffreyFeld-y8b]

Worked like a charm! Thank you so much

[@SharonSmith]

So glad it helped! Thanks for watching!

[@RichieRichIIII]

Some great technical alpha on this vid

[@SharonSmith]

Thank you! I'm glad you found the technical insights helpful. Thanks so much for watching my videos!

[@VersinKettorix]

Very helpful and very clearly presented. It seemed like you did that in one take, so your are either really good at video editing or crazy good at writing and following a script.

[@SharonSmith]

Thank you so much! I’m glad you found it helpful and easy to follow. Thanks for watching!

[@imperialsound929]

Thank you, Very much, You make it look so easy and clear.

[@SharonSmith]

I'm glad you found it helpful! Thanks so much for watching and for subscribing to my Channel!

[@anaelizabethrobledo]

This video was very helpful! Thank you so much!

[@SharonSmith]

So glad you found it helpful! Thanks for watching!

[@abstractmilk2]

This was awesome and so helpful. Thanks

[@SharonSmith]

I’m so glad you found it helpful! Thanks for watching!

[@rupachakma9788]

Thank you very much for the useful content.

[@SharonSmith]

So glad you found it helpful! Thanks for watching!

[@JohnYoga]

Excellent and Thank you!

[@SharonSmith]

Glad to help! Thanks for watching!

[@michelle0705music]

Thanks ❤ really helpful formula, and save my time.❤❤

[@SharonSmith]

Glad to hear you have saved valuable time! Thanks for watching!

[@sadaedost]

Very good explanation 😊

[@SharonSmith]

Thank you! Glad you found it helpful!

[@davidelliott1905]

This is the first Excel video that after watching I successfully completed a lookup! Thank you with yourvideo, I finally did it!! I am so grateful for your video. You made it very simple and easy for me to understand. I know everybody learns and understands differently, but I was beginning to think I would never get it. I have attempted multiple times over the past year they all end in failure...sometimes i even "Break" the departments macros and databases....😱 Finally I won't have to ask the super technical office person that isn't IT but everybody asks them for help...😬 I agree with @isabellayotte having a relevant example that is comparitve to the type of work I do makes a big difference. Thank you so much for your very intuitive and most importantly user-friendly video. I am now a subscriber!

[@SharonSmith]

Oh, thank you so much for taking time to leave such a nice comment. I'm so glad you found my video and examples helpful. I'm proud of you for succesfully learning VLOOKUP & XLOOKUP! Thanks for watching and for subscribing to my Channel. Best of luck to you!

[@tammyco3225]

Omg! I finally get it

[@SharonSmith]

Glad you found it helpful! Thanks for watching!

[@shahmeeriqbal5308]

Keep up the good work :)

[@SharonSmith]

Thank you! I appreciate it!

[@studio7300website]

Thank you!

[@SharonSmith]

Glad you liked it! Thanks for watching!

[@antidiuslaurian5845]

Thanks for the tutorial, it's very informative. But I have encountered issues on extracting columns involving dated (its writing N/A). Again sometimes it is extracting information from the wrong column I am intending to. Can I get clarification on this please?, perhaps there's something I'm doing without knowing... Thanks much.

[@mohammedalyami6139]

Thanks a lot for this exemples , but when i do the same thing you do they gave me (N/A) can you help me about this ?

[@tonyjacobs465]

Hi Sharon, I want to move a whole line of data that has been submitted answering a series of question by our maintenance team to another data sheet, however there are 4 buildings and I want to sort the data so the answer a listed in the correct table for each building.. easy to collect the data but i cant move it to the correct table... i need to sort the data and then if the building is listed move it correctly etc ... an idea how I can do this (please)

[@ChiaAAbdulkarim]

I have a question, if you don't mind. Based on what you have done here, I am doing something similar, but assuming one of the employees has no job title in column D the adjacent cell. I want xlookup xlookup to return a blank value in managers names. Please help me on this. Thanks in advance.

[@rk0020]

How do you handle multiple rows with the same employee? Seems Vlookup only shows the first occurrence.

[@aditya_stackoverflow]

suppose the work email is also missing and if we want to get the work email by dragging the same formula to the right, what will be the process? please tell

[@ImranMalik-dg8xm]

Thumbs up

[@SharonSmith]

Thank you! Thanks for watching!

[@JabbaRankz_]

Im having issues anchoring can you do i video please