Wednesday, May 27, 2015

How to VLOOKUP with Multiple Criteria Using INDEX and MATCH


Basically your match is saying look for "true" if these two conditions are both "true".

When you enter the formula, don’t just press ENTER. Press CTRL+SHIFT+ENTER to tell Excel that it is an array formula. You can tell you’ve done it right because the entered formula will be surrounded in curly braces {}.


No comments: