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

How to do a VLOOKUP – A Look into the basics

Excel’s VLOOKUP function is undoubtedly one of the most popular Excel functions. It can readily interpret and report values in large data arrays and unlike a PivotTable, which needs to be manually updated to reflect source data changes; VLOOKUP will seamlessly update to reflect such changes.

Read More

How to create dependent drop-down lists

This is a fast approach to add a level of sophistication and reduce input error in your spreadsheet. It is a great technique because it will flex, based on the value chosen in a precedent drop-down list.

Read More