Windows Media Video | 2010-09-30 | 1.9 MB | 640x360 | 1000fps | 1 minute, 45 seconds
Transcription: Lesson 14 will continue on with our function reference. The lookup functions allow you to look up one value based on another value. Now my personal favorite lookup function is VLOOKUP. It stands for vertical lookup. It's closely related to HLOOKUP or horizontal lookup. There are also other lookup functions, lookup, match and index. One example for VLOOKUP is to look up up letter grades for your students. For example, Jack has an 85. I want to figure out which letter grade he gets. Here's my sub table right down here. 65 is an F, 70 is a C, and so on. And make sure these are sorted ascending by ...
(.mp4)