Forum Discussion
Index return multiple value with multiple criteria
Hello, I would need help with a formula I can't make it work and can't find help online. I'm trying to return multiple values with multiple criteria (3). Ideally I would like the data separat...
Step 1: Understanding the foundation.
Step 2: Insert a normal MATCH INDEX formula.
Step 3: Change the lookup value to 1.
Step 4: Enter the criteria.
Step 5: Ctrl + Shift + Enter.
Step 2: Insert a normal MATCH INDEX formula.
Step 3: Change the lookup value to 1.
Step 4: Enter the criteria.
Step 5: Ctrl + Shift + Enter.