Power Spreadsheets

Excel VLookup Multiple Criteria with the FILTER Function in 2 Easy Steps (+ Free Easy-To-Adjust Excel Workbook Example)

In this Excel VLookup Multiple Criteria (with the FILTER Function) Tutorial, you learn how to carry out a VLookup for multiple criteria with the FILTER function. The VLookup multiple criteria (with the FILTER function) formula template/structure you learn in this Tutorial isn't the only way to carry out a VLookup for multiple criteria. You may (also) be interested in the … [Read more...]

Excel VLookup Multiple Criteria with INDEX MATCH in 4 Easy Steps (+ Free Easy-To-Adjust Excel Workbook Example)

In this Excel VLookup Multiple Criteria (with INDEX MATCH) Tutorial, you learn how to carry out a VLookup for multiple criteria, with the following constructs: An array formula. The INDEX function. The MATCH function. The VLookup multiple criteria (with INDEX MATCH) formula template/structure you learn in this Tutorial isn't the only way to carry out a VLookup for multiple … [Read more...]

Excel VBA Activate Workbook: Step-by-Step Examples to Activate Workbooks with Macros

In this Excel VBA Tutorial, you learn how to activate workbooks with macros. This Excel VBA Activate Workbook Tutorial is currently under development. Subscribe to the Power Spreadsheets Newsletter to get future updates to this Excel VBA Tutorial. Use the following Table of Contents to navigate to the Section you're interested in. Excel VBA Activate This … [Read more...]

Excel VBA AutoFilter: 19 Step-by-Step Examples to Filter Data with Macros

In this Excel VBA Tutorial, you learn to filter data in Excel with macros. This Excel VBA AutoFilter Tutorial is accompanied by an Excel workbook containing the data and macros I use in the examples below. You can get free access to this example workbook by clicking the button below. Use the following Table of Contents to navigate to the Section you're interested … [Read more...]

Excel VBA Find: 20 Step by Step Examples to Search and Find with Macros

In this Excel VBA Tutorial, you learn how to search and find different items/information with macros. This VBA Find Tutorial is accompanied by an Excel workbook containing the data and macros I use in the examples below. You can get free access to this example workbook by clicking the button below. Use the following Table of Contents to navigate to the Section you're … [Read more...]