• Login
  • Courses
  • Books
  • Cheat Sheets
  • Tutorials Archive
  • VBA Code Generator
  • Contact

Power Spreadsheets

Excel and VBA tutorials and training. Learn how to use Microsoft Excel and Visual Basic for Applications now.

Excel XLOOKUP If Blank Return Blank in 9 Easy Steps (+ Free Easy-To-Adjust Excel Workbook Example)

Excel XLOOKUP if blank return blank

In this Excel XLOOKUP If Blank Return Blank Tutorial, you learn how to create an Excel XLOOKUP if blank return blank formula that: Returns a blank (""); When the XLOOKUP result is a blank cell. The Excel XLOOKUP if blank return blank formula template/structure you learn below relies on the XLOOKUP and LET functions. XLOOKUP and LET are available in Excel 2021 and later … [Read more...]

Excel VBA Select Case Inside For… Next Loop in 7 Easy Steps (+ Free Easy-To-Adjust Excel Workbook Example)

Excel VBA Select Case inside For... Next loop

In this Excel VBA Select Case Inside For... Next Loop Tutorial, you learn how to create an Excel VBA Select Case inside For... Next loop statement to: Repeatedly execute a set of statements (including a nested Select Case statement) a specific number of times; and (On each loop iteration) Conditionally execute a set of statements based on an expression's value. This Excel VBA … [Read more...]

Excel XLOOKUP If Not Found Return Blank in 5 Easy Steps (+ Free Easy-To-Adjust Excel Workbook Example)

Excel XLOOKUP If Not Found Return Blank

In this Excel XLOOKUP If Not Found Return Blank Tutorial, you learn how to create an Excel XLOOKUP if not found return blank formula, where the XLOOKUP function: Returns a blank (""); When it fails to find a valid match for the lookup value. The XLOOKUP function is available in Excel 2021 and later (including Excel 365). This Excel XLOOKUP If Not Found Return Blank Tutorial … [Read more...]

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

Excel VBA Select Case Wildcard

In this Excel VBA Select Case Like Wildcard Tutorial, you learn how to create an Excel VBA Select Case Like wildcard statement to conditionally execute a set of statements based on an expression's value, while: Working with the Like operator; and Considering wildcards. This Excel VBA Select Case Like Wildcard Tutorial is accompanied by an Excel workbook with the data and VBA … [Read more...]

Excel XLOOKUP Wildcard in 6 Easy Steps (+ Free Easy-To-Adjust Excel Workbook Example)

Excel XLOOKUP Wildcard

In this Excel XLOOKUP Wildcard Tutorial, you learn how to create an Excel XLOOKUP wildcard formula, where the XLOOKUP function considers wildcards when searching for a match. The XLOOKUP function is available in Excel 2021 and later (including Excel 365). This Excel XLOOKUP Wildcard Tutorial is accompanied by an Excel workbook with the data and formulas I use. Get this … [Read more...]

  • « Previous Page
  • 1
  • …
  • 3
  • 4
  • 5
  • 6
  • 7
  • …
  • 23
  • Next Page »

I publish a lot of Tutorials and Training Resources about Microsoft Excel and VBA. Here are some of my most popular Excel Training Resources:

  1. Free Excel VBA Email Course
  2. Excel Macro Tutorial for Beginners
  3. Excel Power Query (Get and Transform) Tutorial for Beginners
  4. Excel Keyboard Shortcut Cheat Sheet
  5. Excel Resources
Terms and Conditions

Privacy Policy

Limit of Liability and Disclaimer of Warranty

Affiliate Disclosure

Copyright © 2015–2023 PDS Intelligence Pte. Ltd. All rights reserved.
Excel ® is a registered trademark of the Microsoft Corporation. Power Spreadsheets is not affiliated with the Microsoft Corporation.