Take the time to learn VLOOKUP carefully. It's not very difficult, but students sometimes become confused over it. Ask for help in class whenever you feel unsure.
Online Resources
- tinyurl.com/i0th - video demo on our website
- Assigning grades is easy with a Lookup table - University of Wisconsin-Eau Claire. Tutorial showing how to use VLOOKUP with the common example of converting student marks into letter grades.
- Formulas and Functions - Chabot College. A seven-page pdf file that covers the general topic of Excel formulas and functions, including VLOOKUP on page 6. Also IF, SUMIF, nested functions, etc.
- VLOOKUP Formulas in Microsoft Excel - OfficeArticles.com
- How to use the LOOKUP function in Excel - Microsoft. Not chatty and humorous, but if you take the time to read it, you'll get an accurate and thorough understanding.
- How to use the LOOKUP function with unsorted data in Excel - Microsoft. See comment above.
- Use HLookup and VLookup functions to find records in large worksheets - Another Microsoft resource. Very detailed and thorough. You can download a sample file and walk through the process step by step.
