In this advanced Excel tutorial you’ll learn how to get started using the VLOOKUP function in Excel. VLOOKUP can help you pull specific information from a spreadsheet based upon a piece of information that you know, for example a part number, title, name, etc. The video mentions a great book called A Wrinkle in Time, and if you’re interested in learning more about it, click the link below:

http://amzn.to/2BGsJoA

***Consider supporting Technology for Teachers and Students on Patreon***: https://www.patreon.com/technologyforteachersandstudents

Amazon Auto Links: No products found.

you have great taste lol

This is, by far, one of the best VLOOKUP tutorials. Thank you! Here is my dilemma: I have a project where each worksheet has a set of zip codes. I want to the option to search for a zip code and display the worksheet(s) title where this zip code may be listed. Is this possible?

Straight to the point these vids are great!

Please advice how to Handle Duplication in Lookup

Suppose I did have a worksheet with 1000 rows. Should I leave them as one sheet or break it into several?

Combined vlookup with drop down list from data validation… its much better

Excellent vid, probs one of the best I have seen so far.

I have a question: what if i wanted to find out the number of movies which are PG? What is the vlookup command for this please? I cant seem to get my head around this.

If I want to have a spreadsheet with a bunch of genres associated with each series, how would I go making it look nice and being able to find series specified to genres a, b, and c? So if I’m in the mood to read something with action and comedy, how would I go about that?

Found your teaching methods to be very clear – thank you – I hope to practise this more, as I used to many years ago…need to re-learn as going for a new job soon and need to regain my knowledge…thank you again

Excellent. Thank you.

Best tutorial! Im re-entering the fashion world and this was an amazing refresher! Thank you!

Best tutorial so far!! The tips on the last part really helps to clarify some questions. I would appreciate if you’ll give tips everytime before you end your videos. Thanks!!!!!

Awesome tutorial best one’s I’ve seen!! Keep posting

Do some Microsoft Word documents. Can you teach how to copy data from for Example; Microsoft Dynamics or any System used for company data?

Thank you 😉

I loved everything. Its so easy to follow and understand. Thank you.

Can’t get this to work. I get “there is a problem with this formula” after I press enter.

EDIT: Solved. I had to use ; instead of ,

I love your videos but could you please number them, so that it would be easier to understand which one to watch first? Thanks for taking your time and doing these videos, they are extremely helpful!

You put so much effort and showcase a lot of patience. Thank You

Excellent, very easy and simple to understand. Very helpful

What if you had more than one of the same film title? I’m trying to do this with supplier names but most of them have multiple invoices.

Thanks again

you make this easy to learn, thank you

What if I did not remember the full name of the movie lets say i just typed in “Sherlock” instead of “Young Sherlock Holmes” will it generate the data or it will be an error? Thank you so much

Thank you very much, very helpful. your explain is very good. easy to understand.

THANK YOU THIS IS VERY HELPFUL!

Hi, sir

i have a question regarding hyperlink. i am working on an excel workbook which containing 2 work sheet. (1) sheet 1 (2) sheet 2

sheet 1 : Column A (Item no.) & Column B(Price.) ( number of rows 100)

sheet 2 : Using vlookup with vlookup value (Item no.) and col.index number 2 (Price)

In sheet 1 and in columnB (Price) there is Hyperlink(details of VAT from another workbook)

i want to bring the hyperlink also (which is in price column) with vlookup result in sheet 2.

sir plz help me solve this problem.

great tutorial!! Thanks so much!

Wow… you are the best teacher I have ever come across

Thank you for all your help.

I am really enjoying watching these videos. They are great refreshers for me and they help me understand things more clearer that I was having a hard time with.

Thanks for the explanation

Thanks!!! Can I copy of this spreadsheet to follow your tutorials?

This would be more useful with your movie database, but thanks for your efforts, well done.

Hi Sir, I would like to ask If I can use Vlookup to find all the info If I just type the title of the movie? I mean not just the rating of the movie. Thanks for this video it’s very helpful. Thank you so much.

Thank you sir. 😉

You rock!! This was such an easy tutorial to follow!!

so extremely helpful

Thank you so much for your tutorials. You have an excellent voice for doing this. CK, Toronto, Canada.