Multiple Criteria Lookup With Index And Match
1 minute read We can expand on the Index and Match formula and use an array formula to look up a value based on multiple criteria. This is an array formula so need to press ‘Ctrl, Shift, Enter’ to put curly brackets around the formula. Example 1: In the table below, we can use a … Read more