Excel Forum
Similar Content
Best Lookup Formula in Excel - Index and Match
Tutorial: A lookup using INDEX and MATCH is like a VLOOKUP without the restrictions.  Index and Ma...
Return the Min or Max Value Using a Lookup in Excel - INDEX MATCH
Tutorial: Find the Min or Max value in a range and, based on that, return a value from another rang...
Introducing Logic into Formulas and Functions in Excel
Tutorial: In this tutorial I am going to introduce the idea of Logic in Formulas. A Logic test is a ...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



Excel Magic Trick 576: Dynamic Break Even Chart using INDEX and MATCH functions


See how to Add a point and a dynamic label to a Break Even Chart that marks the breakeven point using INDEX and MATCH functions. This point is dynamic and will change if data is changed.
Videos that show how to create table:
Excel Magic Trick # 254: Data Table Creates 100 Formulas
The Beauty Of Excel #1: Formulas & Functions
The Beauty Of Excel #2: Formulas, Functions & Charts





Got a Question? Ask it Here in the Forum.