Power Spreadsheets

Excel VBA Select Case And Operator in 5 Easy Steps (+ Free Easy-To-Adjust Excel Workbook Example)

In this Excel VBA Select Case And Operator Tutorial, you learn how to create an Excel VBA Select Case And operator statement to conditionally execute a set of statements based on: An expression's value; and The And Operator. The Excel VBA Select Case And operator snippet template/structure you learn in this Tutorial is a specific application of more general Excel VBA Select … [Read more...]

Excel Nested XLOOKUP (Dynamic Lookup Value) in 7 Easy Steps (+ Free Easy-To-Adjust Excel Workbook Example)

In this Excel Nested XLOOKUP (Dynamic Lookup Value) Tutorial, you learn how to create an Excel nested XLOOKUP (dynamic lookup value) formula, where the lookup value for one XLOOKUP depends on the result of another XLOOKUP. The XLOOKUP function is available in Excel 2021 and later (including Excel 365). This Excel Nested XLOOKUP (Dynamic Lookup Value) Tutorial is accompanied by … [Read more...]

Excel VBA Select Case Or in 5 Easy Steps (+ Free Easy-To-Adjust Excel Workbook Example)

In this Excel VBA Select Case Or Tutorial, you learn how to create an Excel VBA Select Case Or statement to conditionally execute a set of statements based on: An expression's value, and Whether this value matches any 1 of several values inside a single case expression (Value1 Or Value2 Or ... Or Value#). The Excel VBA Select Case Or snippet template/structure you learn in … [Read more...]

Excel XLookup Return All Matches in 3 Easy Steps (+ Free Easy-To-Adjust Excel Workbook Example)

In this Excel XLookup Return All Matches Tutorial, you learn how to create an Excel XLookup return all matches formula. The Excel XLookup return all matches formula template/structure you learn below relies on the FILTER function. FILTER is available in Excel 2021 and later (including Excel 365). This Excel XLookup Return All Matches Tutorial is accompanied by an Excel workbook … [Read more...]

Excel VBA Select Case Range of Cells in 8 Easy Steps (+ Free Easy-To-Adjust Excel Workbook Example)

In this Excel VBA Select Case Range of Cells Tutorial, you learn how to create an Excel VBA Select Case range of cells statement to: Repeatedly execute a set of statements (including a nested Select Case statement) for each cell inside a range of cells; and (On each loop iteration) Conditionally execute a set of statements based on an expression's value. This Excel VBA Select … [Read more...]