Microsoft Excel’s XLOOKUP() is powerful, but combined with wildcards, it’s also flexible.

Microsoft Excel has recently introduced three powerful new functions that leverage regular expressions (REGEX) to enhance text manipulation capabilities.

Fortunately, Visual Basic for Applications’ InputBox function supports this task, so you won’t have to work very hard! You’ll learn how to select a range using InputBox in this article.