This demonstration covers the two ways the VLOOKUP function is used in Excel, to match numbers into ranges, and to match exact values to combine data from different sources.
You can watch the recording:
or download the recording to your computer via the link:
vlookup movie download (16 MB, m4v movie file)
and download the example spreadsheet with finished formula