Excel XLOOKUP with Partial Match

Learn how to use XLOOKUP with a partial match.

Below is a link to the spreadsheet used in the video.

Chapters:
00:00 Intro
00:15 Workbook Overview
00:43 XLOOKUP Formula
01:53 Error Explanation
02:26 Resolving Error
03:23 Outro

#xlookup #partial #exceltips

[OfficeMystic]

If you have a unique application for an XLOOKUP, leave a comment below.

[afterlightstorytime]

TEXT to COLUMN is your friend when you want to refresh a column with a new format quickly!😀

[BeaverMonkey]

Your beard gives you an aura of wisdom

[adamq.]

Hey, thanks for the nice explanation.
I have a table and I need to set a formula with multi conditions.
Can you help me which formula and how I'm gonna use it.

[jabbarshaheed]

good evening: I wish you if there was a way to add the new functions on excel 365 to the old versions of Office

[brendanweava]

put the =LEFT() inside of the =VALUE() function and it'll look for the the number 400

[sonyguzso]

Hi I work for a precast construction company. We want to pull out panels that are the exact same on that data sheet to a column based of a set of values, let's say heigth, width and other construction parameters. I think this is the fucntion that would do that, i am right? I havent tried it but maybe some hints of how to go about that would greatly help.! thanks for your videos

[Faisals_Adventures]

Why not use lookup_range & "*" instead of using Left function?

[kimyenchu]

Hello, you don't have a video on the FILTER function so I am posting this question here. I have an employee leave tracker spreadsheet where I want to filter for the employees who are off a particular month. I have 2 date columns: Start Date and End Date. I have a dashboard that shows the leave booking by month. I can filter for the employees who have booked their leave for a particular month, BUT if the duration of the leave stretches to the next month or the month after I cannot show them when I change to the next month because I am filtering on the Start Date only. How can I filter so that the employee shows in all the months where they will be absent? I think I have to incorporate the End Date into it, but I have not got it to work so far.