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

If you need to conditionally split values into multiple columns in Microsoft Excel, consider using the IF() function. Here's how.