Excel VLOOKUP is one of the most ubiquitous spreadsheet functions. Seemingly, an equivalent method to a reverse VLOOKUP will be required in some cases, because a standard VLOOKUP is unable to perform a reverse lookup. This article and video will explore a couple of alternative methods to a reverse VLOOKUP.
How to create a dynamic Waterfall Chart
This follow-up article to “How to create a Waterfall Chart in Excel”, adds a dynamic drop-down list to enable users to change the source time series period of the Waterfall Chart. A dynamic Waterfall Chart delivers flexibility, which a static Waterfall Chart is unable to offer the users of a financial model.
How to create ordinal numbers using Conditional Formatting in Excel
Here is a great approach to create ordinal numbers, which is dynamic and VBA macro-free. It applies Excel conditional formatting to the required data array. The ordinal number formatting will preserve the integer properties of the relevant data array, and will require a number of rules to be created.
Dynamic data ranges in an Excel Graph
An Excel Graph is a great way to communicate a company’s financial performance to stakeholders. A conventional Excel graph has a hard time updating for source data changes; unlike other Excel functions such as formulas or cell formats that update seamlessly. The introduction of dynamic data ranges in an Excel Graph will solve this problem.
DCF Sensitivity Analysis using Excel Data Table
The Excel Data Table “What-if Analysis” tool is one of the most powerful, yet underutilised functions in Excel. It is a great way to deliver a high-level, informative what if analysis of a company’s financial position such as its Net Present Value (NPV) from a Discounted Cash Flow (DCF) schedule.
How to create a dynamic drop-down list from a horizontal range
This is a follow-up to “How to create a dynamic drop-down list in your financial model”, but this article focuses on creating a dynamic drop-down list from a horizontal range or data array. A dynamic drop-down list can equally update and expand seamlessly, whenever additional items are added to a horizontal array of data.