It Also Covers...

The Intersection operator
Concatenation
Creating drop down lists
PivotTable creation
Naming ranges
Converting ranges to Excel tables


Download the sample file here http://www.bluepecantraining.com/port...

This video explains how to solve a VLOOKUP problem where extra spaces in your lookup values cause excel to return the #N/A error. The TRIM function removes spaces in a text string, except for single spaces between words.
------------------------