This video demonstrates how to use Excel's SWITCH functions to lookup across multiple tables.
------------------------