The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80% Then, click OK or Apply button, all the matched values based on the multiple criteria have been extracted at once, see screenshot: