From the course: Excel: Lookup Functions in Depth

Unlock the full course today

Join today to access over 23,200 courses taught by industry experts.

Use the new XMATCH function: Expanded and improved MATCH

Use the new XMATCH function: Expanded and improved MATCH

From the course: Excel: Lookup Functions in Depth

Start my 1-month free trial Buy for my team

Use the new XMATCH function: Expanded and improved MATCH

“

- [Instructor] If you're using Microsoft 365, you have access to a function called XMATCH. This is designed to replace ultimately the match function. It meets all the capabilities of match in a better way and has extended capabilities. I've got a list here in columns A through D on this worksheet called XMATCH, and we're trying to find the first sale from Cincinnati, but also the last sale, and we're also trying to track down sales based on a fiscal year boundary in the middle of the year. Let's first use XMATCH in its simplest way. It'll be just like match, but even simpler. Equal XMATCH, we're simply trying to find Cincinnati in the list. It's in cell H2 here, comma, but we want to look over in column B to see if we can find it there. And that's all we need to do. The default setting is exact match, we don't have to do anything here, simply press Enter. So we find it in row 10 since we use the column reference that…

Contents