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...
Loop through All Worksheets in Excel using VBA and Macros
Tutorial: Ill show you how to loop through all of the worksheets in a workbook in Excel using VBA an...



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.