Professor Excel

Comments 5

    • Henrik Schiffner

      You are right, index-match can do most functions as shown on the table above. But it can’t return a sum of several cells and can’t be used on several search criteria (at least not without further modifications)

  1. Tina

    I have the option of being able to use any of the formula. However, can you advise which one excel processes more easily using less memory or ram. My file is huge, so I’m trying to find alternatives and safe the space without using just values.

Leave a comment