Get my free 3 hour Excel 2013 course. Get 17 training videos to help you learn MS Excel 2013. Click here to get the free course: https://simonsezit.leadpages.net/free-excel-2013-course/

During this Excel 2013 tutorial, get to know VLOOKUP function to automate your data in different cells or sheets when using Excel 2013.

Get the full course on Excel 2013 course here: http://www.simonsezit.com/courses/microsoft/learn-microsoft-excel-2013-training-tutorials/

Watch the Excel 2013 playlist:…

I love the way you are teaching Excel. I have been writing code for a bit and recently started out learning from the beginning and I am glad I did. There are some things that I have been doing the hard way thinking that was the way it had to be written. Some teach Excel by first showing "what not to do" but that really throws me off. With that said, thank you for the way you are teaching. Is there a list of videos that I can access? YouTube often takes me away from your videos while trying to move forward with your teaching. Thanks Again, you're awesome!!!!

you made me the best person in my computer class. thanks

thanks y have a good explanation sir

Thank you Simon. Your simple tutorial has made most of my work easier

British English Narration >> American

your the best

Simon, thanks for the nice tutorial. How do I practice the way you teach? Do you have practice files I can download?

Simon, thank you for the tutorial!

Much better video than another one on youtube that has twice as many view

Hello Simon Sez IT, I wondering if you could help me with an Excel issue that I have not been able to figure out through any of the youtube excel videos. I would be so appreciative. My email is rwntrader@yahoo.com I look forward to your response. Thank you RWN Laguna Hills, CA.

excellent explanation of VLOOKUP

I'm in my first year oif A-Levels and we have an exam on edexcel. Not going to lie I'm terrible at edexcel and the questions are incredibly confusing. Example: "Enter suitable formulae into cells G6–G8 of the ‘Values’ worksheet to show a value

for total cost, total revenue and total profit."

Do you have qany idea on how I can decipher these questions so that they make more sense to me? I understand you may not be an ICT teacher but you appear to know exactly what your doing!! We have the senario and my school thinks its about planning a tourist boat route in relation to time, date and order of attractions to visit. It's also in relation to tidal height. If you think you could help I'd be very grateful!! If you would happily give me your email, I could send you the previous question paper and spreadsheet from last years exam for you to look at and possibly give me some advice but don't worry if you can't. Thank you for this tutorial though, you're great at explanation 🙂

Best explanation, I was really confused about VLOOKUP. thanks a lot for sharing …

Best vlookup video i have seen so far… and trust me, i have looked around. So many Thanks

>click on equals

Thank you!!!

Easy simple to understand tutorial on Vlookup, Pivot Table, Pivot Charts and More

Hey Simon, these videos are great. Do you think you could do a tutorial on Crystal Ball? (Add on to Excel)

Much Helpfull Simon,.Thanks for Sharing.

Thanks for the tutorial. I want to create automatic dimensional reports for a range of different parts. So I only have to change the part ref no to have the dimensions and tolerances, drawing version, etc automatically filled. I will also use this to feed the results of the measurments, from an external table… hopefully LOL

Absolutely Fantastic tutorial!! Thank you very much. So useful!!

Good tutorial. It explained otherwise around specially usage in invoicing.

Great instructional video! Thank you. I agree with the others – VLookup and PivotTables are HUGE when applying for certain jobs.

Thank you

Helped, but frankly its too slow. I waited coz I had no time to waste on searching for better tutorials.

such very good learning place i get knowledge pivot table and vlookup from u

thanks u very much

Trying to apply for jobs where V-Lookup is essential :(…. so thank you for this! I agree that YOU are a life saver!! God bless you

The lookup value in the VLOOKUP function only allows for you to reference one field. How do you use a VLOOKUP or another Excel function to give a value based on 3 or more fields without using INDEX?

This video is a life saver!

Using VLookup is a part of my current assignment in class and I can't do it for the life of me, really helped me out, I'll use functions through the tools way instead of typing them out from now on, makes life so much easier! 🙂

And now onwards to do Forecasting and then hopefully I'll get an A grade on my assignment! ^^

Thanks for the video! 😀