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...
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 Data Validation - Limit What a User Can Enter into a Cell
Tutorial: Data Validation is a tool in Excel that you can use to limit what a user can enter into 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 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.