XLOOKUP with multiple variables
How do you do an XLOOKUP with multiple variables?
XLOOKUP is one of the most powerful tools in Excel, but doesn’t have the functionality to use multiple variables.
Instead, we have to find a workaround.
In this video, I show you three easy ways to do this:
- Use a SUMIFS instead
- Use a helper column
- Nest an XLOOKUP inside of another XLOOKUP
Want to learn more about Excel?
Subscribe to our newsletter to get monthly tips on how Excel can make your life easier, and be notified of our courses.
You can also submit questions to be answered in a future blog post or video, or book a free consultation to find out how we can save your business time and money with our done-for-you solutions.