Loading...

Excel Magic Trick #5: Data Validation List & VLOOKUP

263,954 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Mar 3, 2008

Download Excel workbook: http://people.highline.edu/mgirvin/ex...
Excel! See how to name a cell range, use data validation to add a drop-down list, and how to use the VLOOKUP function to look up values.
See how to do this lightening fast with keyboard short cuts!

Excel Magic Trick 167p1 IF function formula: 12 Examples!

Excel Magic Trick 167p2 IF function formula: 12 Examples!

Loading...

Advertisement
When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...