Excel Forum

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.