From the course: Excel: Lookup Functions in Depth

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

New and expanded capabilities using XLOOKUP

New and expanded capabilities using XLOOKUP

From the course: Excel: Lookup Functions in Depth

Start my 1-month free trial

New and expanded capabilities using XLOOKUP

“

- [Presenter] The X lookup function not only includes the capabilities of V lookup and H lookup, but has additional attributes as well. One of them is the ability to search a list from the bottom up. It's called last the first. The list in column C DNA is sorted chronologically from the beginning of the year until the end. And it represents the efforts of some 30 sales persons and we're tracking their sales day by day. And what we're interested in is finding the last day that one of our sales persons, Karen Roy, when was the last time that she had a sale in 2020? I'm just simply going to copy her name, using the right mouse button and putting it in cell A3. And we use the X lookup function. Remember, anytime you type this equal XL tab gets you there fast. We're looking for Karen Roy comma. We're looking for her name in column C, comma. And when we find a match, we want to get the data out of column D comma. But what…

Contents