Share this article
Improve this guide
Excel Xlookup Formula With Multiple Criteria: How to Use it
This can be done without using other functions
3 min. read
Published onOctober 7, 2024
published onOctober 7, 2024
Share this article
Improve this guide
Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more
Excel functions can be incredibly powerful, and many are wondering if it’s possible to use Excel XLOOKUP with multiple criteria. In this guide, we’re going to answer this question.
How can I use the Excel XLOOKUP function with multiple criteria?
1. Use concatenation
Let’s explain what this formula does:
Since Blue and Jeans are located on row number 3, the return value is 40.
2. Use Boolean expressions
Let’s explain the formula:
How does XLOOKUP work if there are multiple matches?
If there are multiple matches, XLOOKUP will always return the first match.
Can an XLOOKUP return multiple values?
No, this function can only return a single value. If you want to return multiple values, you might want to try using the FILTER function.
Is XLOOKUP better than VLOOKUP?
Yes, XLOOKUP is superior to VLOOKUP in almost every way. To learn about the difference between the two, head to ourXLOOKUP vs VLOOKUPguide.
How to apply XLOOKUP on multiple columns?
As shown in the solutions above, you need to use the & or * operator to scan multiple columns.
It’s pretty simple to use XLOOKUP with multiple lookup values as long as you follow the steps from this guide. To learn more about Excel, we have a guide on how to useINDEX and MATCH functions in Excel, so don’t miss it.
Now that you’re familiar with formulas, did you know that you can quicklyapply a formula to the entire column in Excel? That’s right, and we have a guide that shows you how to do it.
More about the topics:Microsoft Excel
Milan Stanojevic
Windows Toubleshooting Expert
Milan has been enthusiastic about technology ever since his childhood days, and this led him to take interest in all PC-related technologies. He’s a PC enthusiast and he spends most of his time learning about computers and technology.
Before joining WindowsReport, he worked as a front-end web developer. Now, he’s one of the Troubleshooting experts in our worldwide team, specializing in Windows errors & software issues.
User forum
0 messages
Sort by:LatestOldestMost Votes
Comment*
Name*
Email*
Commenting as.Not you?
Save information for future comments
Comment
Δ
Milan Stanojevic
Windows Toubleshooting Expert
Before joining WindowsReport, he worked as a front-end web developer. Now, he’s specialized in Windows errors & software issues.
