Main Profile

At A Glance

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.
Length: 06:26

Contact

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

Want more info about Excel Magic Trick 746: Payback Rule Dynamic Single Cell Array Formula LOOKUP function Array Magic? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question