Office 2010 Class #39: Excel VLOOKUP Function Formula Made Easy (3 Examples)

Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm
The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end.
Topics Covered In Video:
1. See how to use the VLOOKUP function to look up an item in a table and return something to a cell
2. VLOOKUP with Exact Match (Lookup a word)
3. VLOOKUP with Approximate Match (Lookup a number)
4. Data Validation List (Data Ribbon tab, Data Tools Group, Data Validation) Keyboard = Alt, D, L.
5. VLOOKUP for looking up product price
6. VLOOKUP for looking up tax rate
7. VLOOKUP to assign a sales category to a sales number

Category:

Education

Tags:

• Office
• 2010
• Mike
• Gel
• Girvin
• excelisfun
• Highline
• Community
• College
• Busn
• 216
• Computer
• Applications
• Class
• Excel
• VLOOKUP
• function
• formula
• with
• Approximate
• Match
• Exact
• looking
• up
• product
• price
• tax
• rate
• assign
• sales
• category
• to
• number

[7aya84]

hi sir, you are very good at what you are doing, please can i ask if should i make the vlookup table abslute all the time or no need too ? thank you

[ExcelIsFun]

@7aya84 , you do not need to make it absolute all the time. If you will never copy the VLOOKUP formula to another cell, there is no need to make it absolute.

[TheTinkletron]

I am 14, and watching your videos to study for the expert test, i have already passed the certification, but I wanna pass the expert test. Your videos are perfect for this! Thank you!

[ExcelIsFun]

@TheTinkletron , you are really awesome and smart at such a young age!! Keep up the good work!

[stevensiro]

Your wisdom and your skill in teaching is AMAZING! You not only make everything easy to understand but also make it FUN to learn! Love you and each video teaches me so much. I am so thankful for you! :) You ROCK the HOUSE!

[ExcelIsFun]

@stevensiro , I am glad that the videos help!!

[lincolnhachyellick]

Thank you very much for this video! Very helpful!

[ExcelIsFun]

@MrSynths , you are welcome!

[MrSynths]

Very useful, thanks!

[ExcelIsFun]

@dukk77777 , try:

Highline Excel Class 07: VLOOKUP function formula 7 Examples