Excel Forum
Similar Content
Sum a Range with Errors in Excel
Tutorial: How to sum a range of cells that contains errors. This requires an array formula, so it w...
Reference Other Excel Files with Formulas and Functions
Tutorial: In Excel you can use formulas and functions to reference data that is stored in another Ex...
How to Use Multiple Functions and Formulas in a Single Cell in Excel
Tutorial: Lets learn how to put multiple functions and formulas in a single cell in Excel in order t...

Excel Magic Trick 746: Payback Rule Dynamic Single Cell Array Formula LOOKUP function Array Magic

Download file: http://people.highline.edu/mgirvin/
For the Investment Criteria Payback Rule, see how to Single Cell Array Formula. This formula is great because if you change the inputs, the answer will dynamically update. See the LOOKUP function and how it can handle arrays. Barry Houdini at the Mr Excel Message Board came up with this Gem.

Got a Question? Ask it Here in the Forum.