xlookup - if cannot find criteria A then search for criteria B help

[shellwig]

Thank you in advance for your guidance. I'm not sure if I'm heading down the correct path but I'm trying to search for criteria A, if not found then I want to search for criteria B.
I'm using an concatenated xlookup function.

 

[ExcelToDAX]

How about:

=XLOOKUP(B7&E1,A1:A5&B1:B5,C1:C5,XLOOKUP(B7&E2,A1:A5&B1:B5,C1:C5))

 

[shellwig]

Thank you for your help! The above solution works. I was able to resolve via another formula. see below for both solutions.

 

[smozgur]

@shellwig
=XLOOKUP(1,(A1:A5&B1:B5=B7&E1)+(A1:A5&B1:B5=B7&E2),C1:C5) will still pick row 2 if you change E1 to 12/31/2022, because it will find two matches but pick the first match from C1:C5, and it will be 12/31/2023 since it is above 12/31/2022.
Also, I know that it doesn't make sense setting E1 and E2 as equal in this structure but the formula will also fail in that scenario: 1+1 = 2.

However, the other formula by @ExcelToDAX returns the correct value in all cases.

So, I believe the working formula is provided by @ExcelDAX and I am switching the marked solution post. If you think otherwise and I am missing something then please let me know.