Excel VLOOKUP across multiple worksheets

A standard Excel VLOOKUP can refer to values from a specific worksheet. Financial and business planning models are often complex and detailed in their analytics, and therefore require high-level executive summaries or dashboards of multiple worksheets.

The following illustration demonstrates the power of a VLOOKUP with the INDIRECT function to reference a Lookup_value from multiple worksheets.