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.
Read more and to access the example spreadsheet used in this video, please go to https://spreadsheetvault.com/vlookup-...
Watch video Excel VLOOKUP across multiple worksheets online without registration, duration hours minute second in high quality. This video was added by user Strategize Financial Modelling 25 February 2014, don't forget to share it with your friends and acquaintances, it has been viewed on our site 13,085 once and liked it 1 people.