Xlookup 2 criteria 3 Lookup array

[bench205]

Hi I'm wondering how to make this work.

BTW I'm using my phone to send this question.

I do have 2 criteria and 3 lookup array.

Any method to make this work.

 

[Automatrix]

We can't see what's in G19. Anyway, why isn't the date in I18 a criterion?

 

[bench205]

We can't see what's in G19. Anyway, why isn't the date in I18 a criterion?

Yikes, sorry G19 is an employee ID ,1110954.
For i19 what I'm trying to do is like an leave tracker. It will go until 10/31

 

[Automatrix]

Right now your XLOOKUP will look for the string 111095410/03 in strings like 111095410/0310/04, which will not match. Are you looking for a tracker that checks if ID 1110954 is on leave on a given date?