This video demonstrates how to use the RELATED function in Excel's Power Pivot add-in.
------------------------